Unable to See the values for a variable .. Defined with the combination of If & IsNull..
For one of my formula calculations , I have defined the variables at Report level .
And I am unable to see any values for the same ..
Well my formula for calculation is X(Variable) = A*B/C (A,B&C are the measures)
and I have defined my variable as X = If(IsNull[C]);0;(SUM((A)*(B/C)) )
And now my query is that, though the values of [C](measure) are null, the variable is not showing Zero in the cell..
I have selected the number format of the cell as Number (0.00) and even from the Properties of the cell , I have checked the box to show null values..
Please suggest me on this....
I am working on BOXI 3.1