Calculation of Ratio through Script Logic

[former_member225135]

Dear Experts,

I want to calculate ratio of sales for each combination of division group and profit center group through script logic.

Example: Attached in imagecapture.png

script attachedscript.png

Regards,

[sreeraj_sukumaran]

Hi Rahul,

try...

*REC(Factor = 1/ ([C_ACCOUNT].[BS130],[INTERCO].[I_NONE],[FLOW].[F_999],[AUDITTRAIL].[RECLASS],[SEGMENT].[10],[PRCTR].[1001]), C_ACCOUNT = BS122 ....

[former_member186338]

It's technically possible to perform division in script logic but it's meaningless to calculate ratios by script logic - ratios are not summable and will produce strange results in reports...

[former_member186338]

It's a bad idea in general to calculate ratios using script logic. Use dimension member formulas.