Announcements
No record found.
I am calculating average wages for a 3-month period for years 2019-2022. I would like to add a percentage row under sub-totals/total for 2020, 2021, and 2022 to show the year-over-year change (2020 vs. 2019, 2021 vs. 2020, and 2022 vs. 2021). How do I do that?
These are my Row and Column Definitions:
There's not really a good way to do this. Rows do not have a way to specify periods or years, like the column definitions do. You could force an amount with a force calculation, but I'm not sure if that would work in this case.
Let's say that I wanted to force the 3,227.88 amount to another position in the report. This amount is in Column E, Row 153. To do that, I'd have to create a force calculation like this:
This will force the amount into Column B, C and D.
I appreciate the information and advice you have shared for myccpay I will try to figure it out for more.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 282 Super User 2026 Season 2
Aayush Tiwari 219
Subra 211 Super User 2026 Season 2