script logic to calculate the ratios on Totals

[BalaValluru]

Hi All,

I want to write a script logic to calculate the Ratios with Country and Product combination. But the challange here is Totals of each country and product are from local members .( Ex for XYZ Product: 400/2200(local member total) is 18.2% ).

I have around 100 countries .Appreciate can some help to how to write a logic to calculate the ratios based on totals .

Thanks

Kishore

[former_member186338]

For ratios - don't use script logic!!!

Use member with dimension member formula!