Hello,
I am using Framework Manager Version 11.0 and I have the following problem:
I have a measure which has as its regular aggregate "Sum". The values it sums are integers, so the sum is also an integer.
Now, I have as "aggregation rule" "Average". That is, in reports where I look at months, I have sums and when I look at years, I have the average of the month values.
I want to do the following: If my measure is an integer, I want to have it no decimal numbers (i.e. no 5.00 but 5). If it is not an integer, I want to have it at most 2 decimal numbers (so 5.54 instead of 5.546666).
Now, how can I do this? I found under "Format" the option "Number of decimals". But if I use "2" here, every number will have two decimals, even the integers.
I hope you can help me here.
Thank you very much for any answers:)
Best,
CognosUser222