i have a table with 5 expressions and month as a dimension,
first month is empty so all expressions shows zero or null.
unchecked show nulls under moth dimension
unchecked show zero values under add-ons data handling
any ideas ?
There might be a case that these are not zero values but like 0.234545 in decimal format.
try keeping number format as auto and then see what are the values it is giving at place of 0.
Thank you Shraddha, changed all number formatting to Auto, i still see zero values and nulls..
can you share sample app?
For all measures try, Alt(Expression,0)
You can also try
if(expression >0, Expression) for all.
Not so optimal solution but I guess it will work.
Hi Please check the numbers in measures
Retrieving data ...