How can I set value to zero

Sat, 07 Nov 2015 10:44:29 GMT

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.

Re: How can I set value to zero

sunny_talwar — Sat, 07 Nov 2015 12:05:48 GMT

May be like this:

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