SOLVED
QoQ and YoY computation
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
satya04
8 - Asteroid
‎04-07-2023
06:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I would need to calculate YoY and QoQ change for data which is in the following format. Can you please guide me on how this can be done?
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
3 REPLIES 3
gautiergodard
13 - Pulsar
‎04-07-2023
07:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @satya04
You can do something like the attached if you want to keep the data structure unchanged.
I've done the calc using CapEx as an example.
‎04-07-2023
08:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @gautiergodard records till CQ122013 may not have YoY due to unavailability of prior period. Can you please help me understand the logic for obtaining the calculation here?
‎04-07-2023
09:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gautiergodard The result coming in the first row of YoY CapEx should come on the 5th row (Row+4). Can you please guide me on how it can be done?
