How do I...?

return the previous month's record

I'm uploading invoices into our table. Each entry in the table will list the date run, the company name, qty and subtotal. I also want to add a column that populates what the previous month's qty was, so i can add an additional column that calculates the variance.

Can someone help me with what the formula would be to return the previous month's qty?

Thanks in advance

1 vote
Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Noelle shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
Sign in with: Facebook Google
Signed in as (Sign out)
  • Cristina commented  ·   ·  Flag as inappropriate

    Hi Noelle,

    Thank you for reaching out!

    In calculations, you are able to look at the previous month by using a combination of the date functions found in the link below.

    The logic of the syntax shown below is saying, if the month of the "Date field" is equal to the previous month, output the "Quantity", otherwise, leave blank.

    if(month({Date Field})=month(today())-1,{Quantity},null())

    If you would like further assistance, feel free to send your request to with the name of the table/view/fields and any additional details that might be helpful.



Feedback and Knowledge Base