A naukri.com initiative
Dev
2w
298
Image Credit: Dev
#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)
- The problem is about calculating LRR/YOY when there is missing data in a sales table.
- For LRR calculation, the code skips the missing quarter and uses the data from the previous quarter.
- For YOY calculation, the missing quarter is considered as zero.
- esProc Desktop and SPL XLL are used to implement the solution.
Read Full Article
17 Likes
For uninterrupted reading, download the app