Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like
if(PUR_MYOBPurchaseID<0,max(InwardsMonthYr))
Try This
max(if(PUR_MYOBPurchaseID<0,InwardsMonthYr))
try this
if(PUR_MYOBPurchaseID<0,max(InwardsMonthYr))
Hi Shamit,
Check the below exp.
here we converted PUR_MYOBPurchaseID into num format .
=If(num(PUR_MYOBPurchaseID)<0,max(InwardsMonthYr))