Workaround for select in LIS Collected.
I would like to ask for a workaround in case where I had to Compare the different versions(Custom) side by side to show the variance and growth without using select. What I did are the following:
1. In my report Module, I made the GL as line item (Revenue, COS, Gross Profit) for some reason. I have also calculated the GP Margin and COS Margin in the same module per Version.
2. In the Variance module, I collected the whole results and created the line items (Actual, budget, PY) along with its variance and growth line items using lookup(Version)
My concern though, is that i cannot bring the amount and the ratio together in the ratio due to summary that cannot use Formula, so the lowest level GP is correct but the higher hierarchy of the reporting Department/entity will no longer be correct.
I used Select here in the Variance line item and it worked but I would like to ask for a workaround in order for me to be able to create this chart in the ux:
Appreciate all your help!