Skip to Content
0
Jan 13, 2023 at 02:15 PM

Current Year versus Prior Year Calculations using SAP Custom Analytical Query

130 Views

Hi everyone... I come from the old BEx development background and now find myself in the SAP Custom Analytical Query area. I have been building requirement documents rather than doing the actual report/query development the past several years. I have been asked to help out some developers to do some of the Current vs Prior Year build.

I am looking for some quick help to build Calculated Key Figures for Current Year/CY and Prior Year/PY revenues based on one input for Fiscal Year. Basically CY would be revenue as at [Fiscal Year] = 2023. PY would be revenue as at [Fiscal Year]-1 = 2022.

Just need some quick input on how to do this.

Thank you.

Lou