Hi all, I've had some trouble lately with combining the LOOKUP/SELECT function and the summary function, when working with percentages. Let me show the issue with a concrete example. 1) First of all I have a product structure: [img height="75" style="width: 218px;" width="230"][/img] 2) For each product I calculate the Client Rate in my Formulas Module with a Summary set as Formula 3) Afterwards I have a module that collects the numbers, a subset of the module. I can still select Formula for Summary with the function Collect 4) Now I will create a comparison report, however all percentages for parent categories in the product structure are wrong. This is caused by the fact that I cannot select Formula for Summary, while using the following functions: - Dec Y-1 = 'Details CB - Collect YTD/Periodic %'.YTD[LOOKUP: Selections.'Dec Y-1', SELECT: custom version.Actual] - Y-1 = 'Details CB - Collect YTD/Periodic %'.YTD[LOOKUP: Selections.'Period Y-1', SELECT: custom version.Actual] - ...
So my question: Is there a possibility to lookup up the right percentages? As for now the only summary option is for example Average, however it is not weighted, so the results are wrong. I would loved to just use the Formula summary option, however it does not function with LOOKUP's. Many thanks and best regards, Mickel
I too tried to find a workaround but it gets very complicated and most of the times it doesn't work. Removing Lookup from a formula is not a viable solution because you lose the dynamic property along with it.