Hi,
On executing report in AFO, values in a calculated column (A/B *100) shows without decimals in individual row but shows along with decimals in summary row.
Is there any setting needs to be done in order to see decimal values in individual rows also.
For information I am working in AFO 1.4 and have seen same behavior in AFO 2.0 version.
Thanks for reply !!
Hi,
It is solved with one work around solution convert to decimal format.
BR,
Hi,
Any suggestions to the above question 'showing 00 in decimal places in AFO, not real numbers'.
Regards,
Saurabh
Hi,
go to the query definition and define the number of decimals for that key figure there.
reghards
Cornelia
Hi Venkata,
Thanks for reply. Please find below my responses -
1. Connected HANA view to excel, here also decimal values are displayed as (.00).
2. I have created formula like (A/B*100) in HANA.
3. I also tried to change formula in HANA to (A%B), but in that case I was getting wrong results. But, yes with non zero decimal values. So I can not use this formula.
4. But if I talk about any other measure which is not a local formula, shows values with non zero decimal points.
5. I think, in HANA there is any other setting apart from setting Decimal data type with scale.
Any further suggestion is much appreciated.
Regards,
Saurabh
Add a comment