Use of PREVIOUS function

ChrisMcCarthy
ChrisMcCarthy
in Modeling

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

cm test module.png

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

previous.png
Screenshot 2024-05-23 150318.png

Answers

  • rob_marshall
    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
    rob_marshall

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

  • ChrisMcCarthy
    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.

    cm test 2.png

  • CommunityMember111277
    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

    image.png

Categories