Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is this legal statement
Num({$<PRODUCT_TYPE-="*spares","*spare"}>} sum(BILLING_SHIP_PROFIT)/sum(BILLING_AMT),'#,##0%')
I would try this.
Num(
(Sum({$<PRODUCT_TYPE-={"*spares","*spare"}>}BILLING_SHIP_PROFIT)
/
sum(BILLING_AMT))
,'#,##0%')
It Works! Thank You for response!
Great! If appropriate, please mark the above as the answer!
Hi Steven
Similar question I want to perform set analysis will this work
sum( {<product name ='car',Location ='America'>}Sum(sales)*avg(purchase Price))