Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have an order table of CY and PY. I 'd like to calculate the OR Diff for each customer then divide into 3 types according to the OR Diff. I also create a month filter to select. But when I finish the function and select a month, it only shows the customers with OR , not for all the customer, I'd like divide the customer without the OR at that month as 'Order=0' type, How could solve it?
OR_Type=Sum({<FY={'CY'}>} ORVALUE)-Sum({<FY={'PY'}>} ORVALUE)
