Bringing prior year loss into current year income calculation

I have a requirement to include the net loss of a product in the next year income calculation, but only if it is a loss. I keep running into circular references. Any suggestions?

Year 1 Year 2 Year 3 Year 4

Revenue 100 120 140 160

Expense -150 -90 -80 -100

Prior Year Loss 0 -50 -20 0

Total -50 -20 40 60

Accepted answers

All comments

rob_marshall

@Jpowell

Are you using a Custom Time (at the year level)? If so, try using Anaplan's Native Time functionality at the year level and use the previous() function.

Jpowell

Hey Rob,

I am using the native time and trying an If statement with a lag. The issue is Anaplan throws a circular reference error when trying the bring the prior year total into the current year calc of the total.

rob_marshall

@Jpowell

Something like this?

Quick Links

Can you help?

Unanswered questions

Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.
Management reporting table view dynamic column
I have a report page in which we are showing demand based on period selected in another page with column filtered on period selected , however the table in report page is not changing periods if value changed in selection view , can anyone explain if dynamic filtering on column is not there in a slide report
How can I Delete Users in Administration
Now I faced below warning But I cannot find any delete action for those users I don't need anymore Can I have any action to solve this warning?