Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would just like to know if it is possible to subtract two percentages from each other in a straight table. For example i have 3 columns that uses MAT variables to calculate MAT MS in %. First column = MAT-2 MS%, second column = MAT-1 MS% and third column = CY MAT MS%.
So what i want is to subtract MAT-1 MS% from MAT-2 MS%. Example below.
MS MAT -2 | MS MAT -1 | % Subtracted |
29.68% | 31.25% | 1.57% |
0.00% | 3.06% | 3.06% |
13.03% | 12.33% | -0.70% |
I have tried to use the variables and subtract them from each other but its not giving me the growth or decline between the 2 percentages.
If someone knows how to do this please let me know.
Thanks in advance.
Regards
Stevie
Please see the attached file
Hi Guys,
Please see new screen shot - hope this makes sense. Its the best i can explain what i want to see.
Thanks
Regards
Stevie
Can you upload a sample app with scrambled data? This looks fishy..
I agree that the Column(4)-Column(3) should give the correct results, can you check whether you have marked this expression to be relative? If so, please uncheck the Relative checkbox for this expression.