If value = null then “ ” else value SSRS EXPRESSIO

问题:

value 1 is a retail price decimal value 2 is the difference between 2 retail costs both are decimals

=IIF(Fields!Prorated.Value is null,"",Fields!Prorated.Value)-Fields!Retail.Value fixxed !!!

Fixxed ^^

=IIF(IsNothing(Fields!Prorated.Value),"",(Fields!Prorated.Value-Fields!CurrentRetailPrice.Value)/Fields!Prorated.Value)

Failed ^^ this one is shown as a % difference

this has not worked what would be another way around this

回答1:

Try this:

=IIF(IsNothing(Fields!days_Prorated.Value),"",Fields!Prorated.Value-Fields!Retail.Value)

For your comment try this:

=IIF(IsNothing(Fields!Prorated.Value),"",(Fields!Prorated.Value-Fields!CurrentRetailPrice.Value)/iif(Isnothing(Fields!Prorated.Value),1,Fields!Prorated.Value)

You have to validate it twice in this case.