Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I'm trying to replace '-' values with 0 in pivot table but it is not working.
tried with below functions
1. If(isnull(Expression),0,Expression)
2. Alt(Expression,0)
nothing is working. Can you please suggest me on this.
Thank you!
use your expression as below using set analysis:-
sum({<Region={"=len(Region)>0"}>} Count)
this will replace null with zero too
RangeSum(Expression, 0)
This worked for me but if there is multiple Column dimensions it doesn't work on the additional columns