Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I want to convert the following expressions into set analysis
1. Sum (if(Supplier_ID = 3, Cost*1.12,if(Supplier_ID = 991, Cost*1.15,Cost)))
2. Sum(Cost)/Sum(if(ActionType_ID = 4 AND Source_ID =1,1,0))
3. Sum(if(ActionType_ID = 5 AND (Source_ID = 1 OR (Source_ID = 3 AND Moked_Mail=0 AND (OrigRegsTime >= v_MinDate or OrigRegsTime = '0000-00-00'))) or (ActionType_ID = 7) or (ActionType_ID = 8), 1,0))
4. Sum(if(ActionType_ID = 5 or ActionType_ID = 8 or ActionType_ID = 13 ,1,if(ActionType_ID = 6 or ActionType_ID = 7,-1,0)))
Thanks in advance,
Hi Shani,
First can be done for example like that:
sum({<Supplier_ID={'3'}>} Cost * 1.12)+sum({<Supplier_ID={'991'}>} Cost * 1.15)+sum({<Supplier_ID-={'3','991'}>} Cost)
You need to remember that it will not sum the cost for rows which have null for Supplier_ID field (if such rows exist in you data of course).
You can do the rest with similar approach.
BR,
Milosz