Skip to main content
T
tdugas
Member
May 22, 2023

All prior Quarters in FY

  • May 22, 2023
  • 1 reply
  • 0 views

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

 

tdugas_0-1684763092483.png

 

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
May 23, 2023

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.

Terms & ConditionsAccessibility statement