Variance Calculations and QTD Formula
I’m working on developing a Variance Analysis Module.
I have reviewed the posts on Community and found this training that has been helpful.
I used the below link to develop the Comparison and Variance Modules:
For the Comparison Module – I added a Quarter Value and LY Quarter Value as well. See screenshot for Comparison Module.
For the Variance Calc YTD Module: See screenshot for Variance YTD Calc Module.
1) Orange highlights - The formula is setup similar as the training but I’m not able to pull in any data? What am I missing here?
2) Yellow highlights - I would also like to setup a formula for QTD. I know this is not an option in the Time Settings. What is the best way to calculate QTD?