Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unable to See the values for a variable .. Defined with the combination of If & IsNull..

Hi Techies,

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

Former Member
Not what you were looking for? View more on this topic or Ask a question