Hi,
Is it possible to have a formula based purely on values in the results row? e.g.
Col A Col B Col C ColDl
Results Row 4 5 1 40%
Where Col D is Col A as a percentage of the total. I can create a formula for individual rows but not for the results row where it just seems to sum individual percentages.
Thanks
In query designer > Properties for a Key Figure > Calculations > Calculate Result As > Nothing Defined,
it should use the same formula to calculate the resutl what you have defined for the rows instead of just summing up the individual averages.
Regards,
Gaurav
Hi Gaurav,
i have done what you have suggested:
In query designer > Properties for a Key Figure > Calculations > Calculate Result As > Nothing Defined,
I have set that, despite the rows are calculated as per formula defined in the key figure but the result field is not. The formula is only applied for the rows but not for the result. The result is olthough i have the setting you suggested a summation of that whole column and thats wrong.
Can you or anybody else help.
Thanks and regards,
Murat
Add a comment