Forum Stats

  • 3,758,396 Users
  • 2,251,380 Discussions
  • 7,870,177 Comments

Discussions

Calculate - Month LY Complete and FYLY Complete ?

Hi Team,

I have columns like MTD,FYTD,FYTD LY (these columns go by to_date formula in RPD) and I need to calculate Month LY - Complete(Ex - Aug2020 Complete) and Fiscal Year LY (Complete Year) (Ex - Mar2020 to Feb2021).

On the report I Will be passing only Date column So I cannot Use the Ago function for the above requirement.

Is there way to calculate these calculations either in RPD or Front end?

Thanks,

Steel.

Tagged: