If value = null then " " else value SSRS EXPRESSION issues

reporting-services ssrs-expression
Cladback picture Cladback · Sep 22, 2015 · Viewed 63.8k times · Source

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

Answer

alejandro zuleta picture alejandro zuleta · Sep 22, 2015

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.

Related questions

SSRS Field Expression to change the background color of the Cell

I'm trying to write a field expression for a Cell in my report where I have to change the background color of the cell depending on the string value in the cell. Ex: if the column has a value 'Approved' …

Read More
Reporting Services Remove Time from DateTime in Expression

I'm trying to populate an expression (default value of a parameter) with an explicit time. How do I remove the time from the the "now" function?

Read More
SSRS Expression for IF, THEN ELSE

I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression. =if(Fields!ExitReason.Value 7, then if (Fields!ExitReason.Value 1, else if (Fields!ExitReason.…

Read More