This content has been marked as final.
Show 3 replies

1. Re: Table calculation: divide by diagonal value (or column maximum)
Deepak Rai May 22, 2018 10:11 AM (in response to santiago bustos)1 of 1 people found this helpful{FIXED Cat 1,Cat2: SUM(Value)}/{FIXED Cat2:MAX(Value)}

2. Re: Table calculation: divide by diagonal value (or column maximum)
santiago bustos May 23, 2018 7:26 AM (in response to Deepak Rai)1 of 1 people found this helpfulDeepak, thanks a lot for the answer!
Although it didn't seem to work just like that, I understood your logic, and ended up using the following code:
{ FIXED [Cat 1],[Cat 2]: SUM([value])}/{ FIXED [Cat 2]: MAX({ FIXED [Cat 1],[Cat 2]: SUM([value])})}
The only difference is that on the denominator the division uses the max of the numerator, instead of 'value' itself.
Hope this helps someone else with the same doubt.
Regards,
SB.

3. Re: Table calculation: divide by diagonal value (or column maximum)
Deepak Rai May 23, 2018 7:35 AM (in response to santiago bustos)Great!! Pl close the thread to help someone