How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I wish to make the formula dynamic and not use static values like TIME.FY19
I have a "Shipments" module that is having monthly scale, time dimension. Line item "ShipmentRatio %" is a percent formatted metric.
I have another module called "Yearly Assumptions", which is notdimensioned by time.
In the Year Assumptions module, I wish to calculate a line item as follows:
To clarify @LipChean_Soh 's solution, the first line item that he mentioned (which should be added in the Yearly Assumptions module) should have the formula Parent(Time.'Current Period'). This will grab the current year. Then the second line item will use this to lookup the current year's Shipment Ratio average.