All prior Quarters in FY

[tdugas]

I am working on a report that shows YTD, Quarters and Months based on the pov.  The Year and Month works fine however for Quarters, when I pull a non quarter months I am getting the inverse of the prior quarter.  The formula I am using for the quarters is below.

T#quarter(|PovTime|).allpriorinyearinclusive:v#QTD

[JackLacava]

Remember that OneStream stores YTD behind the scenes. If you have a zero stored in post-April months, the YTD value at the end of the quarter will be zero; because you use QTD, the value for the quarter might end up being negative. This is just a theory.

I suspect what you want is switching the view to Periodic for those Quarter columns.