Skip to main content

return the previous month's record


1 comment

  • Leeana Ramos
    Cristina commented  ·  

    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.

    Date Functions

    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.




Please sign in to leave a comment.

Powered by Zendesk