Suppress when value is null in expression

[bsbernabe]

Hello There,

This is my expression below and i want to suppress when value is null in expression how can i ?

Expression

=if ([Days] <= 365,.10,

    if ([Days] <= 730,.20,

    if ([Days] <= 1095,.30,

    if ([Days] <= 7460,.40,

    if ([Days] < 1825,.50,

    if ([Days]  >= 1825,.60))))))*(VALUE))

Best Regards,

Bing

[Anil_Babu_Samineni · Accepted solution]

Perhaps these? And, Just replace with red context to any one from below list

=if ([Days] <= 365,.10,

    if ([Days] <= 730,.20,

    if ([Days] <= 1095,.30,

    if ([Days] <= 7460,.40,

    if ([Days] < 1825,.50,

    if ([Days]  >= 1825,.60))))))* (If(Len(VALUE)>0,VALUE))

OR

Sum({<VALUE -= {' '}>} VALUE)

OR

Sum({<VALUE -= {' '}>} VALUE)

OR

Sum({$<VALUE -= "=Null()">} VALUE)

OR

If(Not IsNull(VALUE), VALUE)

And even, This works

sum({$<VALUE={"=Len(Trim(VALUE))=0"}>} VALUE)

[prma7799]

For this

Sum({$<VALUE -= "=Null()">} VALUE)

And even, This works

sum({$<VALUE={"=Len(Trim(VALUE))=0"}>} VALUE)

Sum({$<VALUE -= {"=Null()"}>} VALUE)

sum({$<VALUE-={"=Len(Trim(VALUE))=0"}>} VALUE)

[bsbernabe]

Hi Anil,

Thank you so much for your support, your expression is workings

Highly Appreciated.

Best Regards,

Bing

[bsbernabe]

Hi PM,

Thank for your Support.

Best Regards,

BIng

[prma7799]

If this is helpful to you then please mark this reply as helpful it is helpful to others

[Anil_Babu_Samineni]

I believe First one should work, But in syntax it may shows wing error in red area of null. That is bug (It may work)