Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We need to display only null values in fronted chart,this is the requirement according to that i have created, for i wrote below expression
(if(IsNull([Product Number])=-1 ,'' , Null()) , I can find all null values ,But some product still shows values those are 950093 ,552825 ,552824 and 552823 this wrong , my answer is if have value we need to hide that entire row Please below screen shot.
Could you please help me.
Advance Thanks
Munna
try
=if(len(trim([Product Number]))=-1, 'Null())',
Hi,
Try this expression, no need of calculated dimension
=Sum({<[Product Number]-={'*'}>} MeasureName)
Note: Replace MeasureName with your actual field name.
REgards,
jagan.
Hi,
You can try,
=If(Len(Trim([Product Number]))=0,'')
HI,
Try this expression
Sum({1-<[Product Number]={'*'}>}Measure)
Hi Srinivas,
what is the name of the first column in your table??..if that first column is any key for that table (if not a measure), then use below expression instead of your first column as caluculated dimension.
(if(IsNull([Product Number])=-1 ,'your first column name here')
Hope this will help..