pivot table with null

[surajdhall]

Hi All,

I have horizontal pivot table and i have issues to find/calculate nulls values in the expression using if() condition.

I am using below expressions to calculate sales, if no sales available i want to throw blank. But in few cases it returns blank, but in other cells it returns '-'

if(not isnull(sum(sales) or len(sum(sales)) >0,

sum(sales),' ')

Please help

[sunny_talwar]

Would you be able to share a sample to show the issue?

[el_aprendiz111]

Hi,

1 Option...

[surajdhall]

I will prepare the same in few minutes. Thanks

[surajdhall]

Hi Sunny

you can see down arrows, where i want blanks, as there is no data in the next month, so i want bank instead of arrow.

!

Please help!

[sunny_talwar]

So wherever you have NA, you would not want to see any arrow?

[surajdhall]

Yes. But not in below case. In below case. For April there  is up arrow as there is data in May, But no arrows should be shown in Mar, below is correct. But in previous screenshots that i posted there are down arrows, which are incorrect.

[sunny_talwar]

I understand the up arrow in May-2017.... but why is there an up-arrow in Apr-2017? Mar-2017 and Apr-2017 have both N/A... why up arrow for Apr-2017 then?