How can I set value to zero

[#1]

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.

[sunny_talwar · Accepted solution]

May be like this:

1 - If(Len(Trim([EKSTRA İSKONTO])) = 0 , 0, [EKSTRA İSKONTO])