Product type wise sum is not showing for multiple currency

[milindnikumbh]

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.

[sunny_talwar]

Try this

=Num(Sum(QTY * RATE * Pick(Match(Upper(CUR), 'INR', 'GBP', 'EUR', 'USD'), 0.02, 1.60, 1.32, 1))/1000000, '#####.000')

[milindnikumbh]

Thanks Sunny. But no luck. Its same.

[sunny_talwar · Accepted solution]

I am not sure I understand... is this not what you want?

What is wrong?

[milindnikumbh]

I do not want material / customer / currency dimensions in my table.

Wants product type / Qty / Vaue in  straight table.

[sunny_talwar]

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?

[sunny_talwar]

Where do you see material / customer / currency dimension in the snap shot above?

[sunny_talwar]

Did you even try to open the qvw attachment from my response above?

[milindnikumbh]

Thank you so much. Its resolved. What was the issue in my if statement .

Thanks a ton.

[sunny_talwar]

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?