Hi,
I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input.
Thanks
Hello @shubhamrawat ,
If I understand correctly, you need 3 line items
Now, I understand that the question is how to achieve the yearly income. If you use YEARVALUE(Monthly Income) [https://help.anaplan.com/5df8cf5a-6609-4e14-832f-ddff9b29326b-YEARVALUE], you should be able to get the yearly entry for every month (if the lowest granularity of the module is Month).
Cheers!
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…
