Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i convert this expression into set analysis expression
if(sum(Stock_value)-sum(Stock_qty)>0,sum(MAP)*fabs(sum(Stock_value)-sum(Stock_qty)))
What dimensions you are using?
model
Try this
sum({<model={"=(sum(Stock_value)-sum(Stock_qty))>0"}>}MAP)*fabs(sum(Stock_value)-sum(Stock_qty))