Skip to Content
0

Calculation of Ratio through Script Logic

Dec 30, 2016 at 02:24 PM

58

avatar image

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,

capture.png (5.5 kB)
script.png (50.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Dec 30, 2016 at 04:52 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
SREERAJ SUKUMARAN Jan 03, 2017 at 03:06 PM
0

Hi Rahul,

try...

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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...

0