IN our implementation, there is seperate category to calculated millions, which uses the amounts from 'Actuals' and converts in to 'Millions' and stores theamount in 'Million' cateogry.
This is since the amounts needs to be seen in millions, when the reporting amounts runs in to 'Trillions'.
Has some one seen this kind of 'Millions' being created as category which just converts the values from 'Actual' catergory in to 'Millions'.
Is there any better way to handle this situation. Appreciate inputs.