Forum Discussion

tdugas's avatar
tdugas
New Contributor III
2 years ago

All prior Quarters in FY

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

 

 

Cube View
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    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.