IF

[Pujitha]

Hello all,

=If(VLAGreaterThan=1,'<30days',If(VLAGreaterThan=3,'>30days',If(VLAGreaterThan=6,'>60days'))) is there any way can we write this expression without if and when I giving this in Calculated expression for "PIVOT TABLE" . Can we write this expression without "IF" please help me out.

[sergio0592]

Hi,

Try with =

pick(match(VLAGreaterThan,'1','3','6'),'<30days','>30 days','>60 days')

[juraj_misina]

Why don't you create a new field in script with '<30days','>30 days','>60 days' values and then use that field in the pivot table as a dimension?

[MarcoWedel]

one possible variation:

Pick(Match(VLAGreaterThan,1,3,6),'<30','>30','>60')&'days'

or to keep the sorting order of any other strings:

Dual(Pick(Match(VLAGreaterThan,1,3,6),'<30','>30','>60')&'days',VLAGreaterThan)

hope this helps

regards

Marco