price quantity analysis translation effect breakdown in FCC
Summary:
I have build a price analysis variance split between two revenue numbers in FCC. We use it in Entity Currency but as a next step we would additionally like to visualize the currency translation impact at Parent Currency.
Content
I have build a price analysis variance split between two revenue numbers in FCC. The end-user can select in a report from a list of scenarios the scenario to be used for comparison with the POV scenario and year and if this dynamic calculation should be done between against this year of prior year data (list = Custom 2 members). This works then in combination with calculated accounts for P and Q. The calculation works fine in Entity Currency so we started analyzing this at higher levels in entity dimension.