Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to solve this.
=sum({$<dummy={1} $(vQtySubSet) $(vPriceSubSet), Price_Reference_Price_exists = {1}>} InvoicedQuantity)
I need explanation for this formula that whether the 3 variables "$<dummy={1}", "$(vQtySubSet)" and "$(vPriceSubSet)" are doing multiplication in this formula or not.
I doubt it, can you tell us does this expr gives you any result? What are the variable expr inside?
Expression wrong to me, Perhaps this way?
=sum({$<dummy={"=Only({1} $(vQtySubSet)*$(vPriceSubSet))"}, Price_Reference_Price_exists = {1}>} InvoicedQuantity)
yes it gives us result.
variable expressions are as below
vQtySubSet =If(vQty_Filter = 'On',',InvoicedQuantity = {">$(vQty_Min)<$(vQty_Max)"}',)
vPriceSubSet= If(vPrice_Filter = 'On',',NetPriceLC = {">$(vPrice_Min)<$(vPrice_Max)"}',)
The expression which I have mentioned before, is absolutely correct.Even it is returning the desired result as well.