anirudh 
-
Re: Formula/Ratio Summary methods
Hi Alexandru, Not sure if I fully understood but why not split out the NSV Category into a line item which does not have formula summary and has only: NSV/KG[LOOKUP: List.Parent] Call this line item …1 -
Re: Countifs Function
Hi ch, You do not need to create another module, simply create a new line item called Headcount in the model with dept and employees as dimensions. However, add the dimension of month to this line it…2 -
Re: How to get the average of the last 3 month from the same line item for Forecast version?
Sure! Try this in the 3 months average: IF MOVINGSUM(Upload Amount, -2, 0, AVERAGE) = 0 THEN POST('3 Months Average', 1) ELSE MOVINGSUM(Upload Amount, -2, 0, AVERAGE)2 -
Re: How do I sum across dimensions other than time?
Hi iosman, This is certainly possible. Simply create a new line item called Total Sales, without any dimensions and with the formula as Sales. Then create a third line item called % of Total Sales wi…2 -
Re: How to hide Modules and its views under Contents section
Hi Usha, Please switch the drop-down: Show new items On to Off and repeat this for each functional area. This drop-down will prevent new modules in a functional area from showing up in the contents p…2
