Dynamic Dimension Logic

[#1]

Hi Folks,

I am facing some issue in my development,

The logic is that I have Country Column with different Price Rate, Each country has its own currency Rate.

now the problem is that i am not able to multiply Amount with Respect to the Currency of the different  Country.

& I need it into pivot table, any suggestions will be appreciated.

Thanks in Advanced,

Max

[tresesco]

May be you are trying like:

=Sum(Price)*CurrRate       // not correct, rather try like

=Sum(Price*CurrRate)       // could work for you

[#3]

Hi,

Try to do the Exchange rate calc in the script level. It would make things easier.

Regards,

Prabhu

[#4]

Hi Tresesco & Prabhu,

Thanks, but i do not want to make any changes into script level & Currency Factor is identify by their Code based on it needs to be define.

[tresesco]

Not very clear, could you post a sample qvw or explain with example? However, the solution I suggested was meant for front-end and not script.

[#6]

Hi Tresesco,

Thanks for your help it works fine in single case. but in my case there are two type of currency exist Type 1 & Type 2, where both types are depend on two different dimensions, in that case your given solution get failed so i want to make it as dynamic.