How can I do an average on numbers and exclude the zeros? For example, Year 1 = 10, Year 2 = 0, Year 3 = 4, therefore if ignore Year 2, average is 7 (and not 14 divided by 3)?
1) Create a "Count" Line Item formatted as a Number
2) Formula = IF (line item) = 0 then 1 else 0 --> this will make a count for the denominator for the average.
3) Create a line item for the calculation, here the Ratio summary can be used or the Sum of Values / Count
I am trying to set the model in Time to be only months and remove Quarters and FY. For example the course structure example is the following: Although my results include Q and FY: I already tried changing the summary and leaving none for time Time Summary, all it does is to leave it blank, but still showing.
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
