Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Expert ,
I am not able to get the product type wise sum of quantity for multiple currencies.
Qty * Rate total is coming for some product types who have single currency.
Please suggest your solution. Files are attached for your reference.
Thanks & Regards,
Milind.
I am not sure I understand... is this not what you want?
What is wrong?
Try this
=Num(Sum(QTY * RATE * Pick(Match(Upper(CUR), 'INR', 'GBP', 'EUR', 'USD'), 0.02, 1.60, 1.32, 1))/1000000, '#####.000')
Thanks Sunny. But no luck. Its same.
I am not sure I understand... is this not what you want?
What is wrong?
I do not want material / customer / currency dimensions in my table.
Wants product type / Qty / Vaue in straight table.
Also, same as in what? I see that A comes with the value 4.126 where as the original expression was null. How are they the same?
Where do you see material / customer / currency dimension in the snap shot above?
Did you even try to open the qvw attachment from my response above?
Thank you so much. Its resolved. What was the issue in my if statement .
Thanks a ton.
Before I explain you the issue with your if statement, I would love to know how did the expression I gave not work for you? Did you even try it or just saw it and said nahh this isn't going to work?