3 of 3 people found this helpful
Please use ZN function to display Zero where there are null values.
2 of 2 people found this helpful
Hi Aditya - Create a calculated field using ZN() function . Eg ZN(Sales).
Step 1: Open a Calculated Field and type Zn (lookup (sum ( [Sales]),0)
Step 2: Drop it on Text or Label Marks card
This will give the desired result.
Even after creating the calculated field and dropping it in the text marks card it still it looks empty
Even after creating the calculated field and dropping it in the text marks card it still it looks empty. Am I missing anything ?
replace your measure name below and let me know the the results.
ZN(LOOKUP(SUM([Max Sum Loc]),0))
that's the measure name
after creating this calculated filed I drop it into the text ,Marks
Still the Zero doesn't show up ! the cells remain empty
I have also used this option
Analysis --> Table layout --> Show empty rows
Hi whatever dimension you have chosen create a duplicate of the dimension and drag the original on the row and the duplicate on the column and drag the Zn Calculated field in the Txt or label.
Follow the below link for more help.
That's not the requirement. The dimension is sales person name. Why should I copy and put Sales person name in the column and row ?
It show the intersection, between the sales people as zero which does not solve the issue
use if condition:
IF MaxSumLoc = null then 0 else MaxSumLoc END
apply the same and let me know..
still zero's do not show up
Hi Aditya, could you post a packaged workbook so we can try it ourselves?