Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a load script where this formula fabs(floor(num(interval(Performa_Window_Date - [Last BTR Cust], 'm'))*24*10)/10), 0) as diff for Performa_Window_Date: 28/12/2020 01:00:00 and Last BTR Cust: 14/01/2021 10:00:00
should be -417 but it is showing as 417 in the chart.
Hello,
FABS() function returns the positive number of calculation.
Hope this helps.