Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I set empty value to zero value in pivot table expression.
(1-num([EKSTRA İSKONTO],'#.###'))
I try if statement but I cant fix.
if column is empty, return all expression zero.
I want to return zero [EKSTRA İSKONTO] if its empty.
May be like this:
1 - If(Len(Trim([EKSTRA İSKONTO])) = 0 , 0, [EKSTRA İSKONTO])
May be like this:
1 - If(Len(Trim([EKSTRA İSKONTO])) = 0 , 0, [EKSTRA İSKONTO])