Use of PREVIOUS function

ChrisMcCarthy · 2024-05-23T14:04:57+00:00

There was an error rendering this rich post.

I'm sure I've used the "PREVIOUS" function before without any problems but on trying to use recently it doesn't now seem to be returning the values I would expect

As you can see the formula Previous(Volume) is specified, which I would have expected it to return the FY23 volume value of 218,116; however, this doesn't seem to be the case. I've included some design view screenshots in case that helps

Accepted answers

All comments

rob_marshall

@ChrisMcCarthy

I may be misunderstanding, but it doesn't look like you are using the Previous() function, but rather a lookup to the previous year.

rob_marshall

And, if you are only looking at the year, change the timescale for Previous Volume to Year instead of Month.

ChrisMcCarthy

Hi Rob,

Appreciate your response - sorry it was me not having put the correct screenshot in before, this is the one that I should have put in and it wasn't returning expected values - however having volume set as timescale of month and previous volume set as year seems to have rectified this, thank you.

CommunityMember111277

Hi@ChrisMcCarthy , any reason why year (volume) vs year(previous volume) is not working in your case. what was the expected value & what were you getting? have you tried drilldown option to identify the issue.

This is what I get with the previous function

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
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…