Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can I get help transforming this logic into a syntax;
IF 'Current Date' minus 'Transaction Date' greater than 180 days and Balance(Fieldname) is greater than zero than '> 180',
IF 'Current Date' minus 'Transaction Date' greater than 90 days and Balance(Fieldname) is greater than zero than '> 90',
IF 'Current Date' minus 'Transaction Date' greater than 60 days and Balance(Fieldname) is greater than zero than '> 60',
IF 'Current Date' minus 'Transaction Date' greater than 30days and Balance(Fieldname) is greater than zero than '> 30' AS AGEING;
Hi,
See the below mentioned syntex. this very usefull for you.
if(Interval(Today()-DueDate,'DD')<=0,Dual('Not Due',0),
if(Interval(Today()-DueDate,'DD')<=30,Dual('1-30',30),
if(Interval(Today()-DueDate,'DD')<=60,Dual('31-60',60),
if(Interval(Today()-DueDate,'DD')<=90,Dual('61-90',90),
if(Interval(Today()-DueDate,'DD')<=120,Dual('91-120',120),
if(Interval(Today()-DueDate,'DD')<=150,Dual('121-180',180),
Dual('> 180',181)
)))))) as AGEING,