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: