IF statement expression

[shamitshah]

Hi,

I need help with the following if expression which is currently incorrect. The statement should show the InwardsMonthYr if PurchaseID <0, otherwise leave it blank.

if(PUR_MYOBPurchaseID=('<0'),max(InwardsMonthYr))

Thanks

Shamit

[avinashelite · Accepted solution]

Try like

if(PUR_MYOBPurchaseID<0,max(InwardsMonthYr))

[er_mohit]

Try This

max(if(PUR_MYOBPurchaseID<0,InwardsMonthYr))

[Chanty4u]

try this

if(PUR_MYOBPurchaseID<0,max(InwardsMonthYr))

[ramasaisaksoft]

Hi Shamit,

Check the below exp.

here we converted PUR_MYOBPurchaseID into num format .

=If(num(PUR_MYOBPurchaseID)<0,max(InwardsMonthYr))