How to display one previous month of custom time

Tkinoshita
Tkinoshita
in Integrations and extensibility

I am using a list with its own time.
If it is a normal time, I can set it to the previous month by doing Time-1, but I can't do it with my own time.
Please let me know how to do this.
Thank you in advance.

Answers

  • SriNitya
    SriNitya

    Hi,
    If your custom list as below, then based on your current date you can get the previous month.
    Refer the screenshots.

    image.png
    image.png
    image.png
  • lokeshm
    lokeshm

    Hi, I didn't get your question but I assume Your custom list contains values like this (Jan 23, feb 23). you can try using the code with numbers and then write the formulas to show the previous value and then you can refer this line item using the look up .

    image.png
    image.png
  • Dikshant
    Dikshant

    If you make the code 1-12, it makes it easier to calculate the previous month. But the other approach where we first converted the fake time to Anaplan time and then calculated the previous month and then converted it to fake time is also a good workaround if you don't want to make numeric codes in the fake time list.

Categories