I have data formulas like this. How do you change SUM to Formula in summary. So Growth Calculate on Summary Level its wrong.
@adisulyadi Do mark the 'Accept reply as solution' to a reply if it resolved your query! It encourages community members in general and also helps future members who may have the same question but may skip over the thread assuming it has no solution
Regards,
Anirudh
Hi @adisulyadi
You can'y use summary as formula with PREVIOUS function in same line item.
Create one more line item and just refer to the line item which having previous function in your formula and for this line item you can set the summary as formula.
Hope this helps!
Thanks
Akhtar
You will not be able to set the summary method to Formula for the time dimension if using a time-based function like previous() If you try you will get an error like the one below:
However, depending on what you want to show you may be able to use the other summary methods to achieve this. For example if you wanted to show what the value was in month 12 of the prior year you could set the summary to Opening Balance ( month 1 of current year = month 12 of prior using Previous).
@adisulyadi
Break your formula into multiple line items and you should be able to get your results. Add Two line items Previous Premium and Previous GTV - Both should have SUM at Summary Level and then do the simple division in the Output line item and change the summary to Formula.
@Akhtar.shahbaz unfortunately it doesn't work that way - simple refer will still not have the right values at aggregated levels because technically there is no formula, it is just refer.
Hope this helps
Misbah
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…