Forum Discussion

vijay's avatar
vijay
New Contributor III
3 years ago

Multiple cell values in Databuffer same intersection

hi ,   Am getting mutiple values from the databuffer for the same intersection. Database has  Status1 ,Value1  then up to ...Status 12 ,Value 12...  I beleive that only the Staus 12 and Value 12 co...
Finance
vijay's avatar
vijay
New Contributor III
3 years ago

Thanks Eric ..Can we get the YTD value of those intersection . I tried the below but still getting all the 12 months data for YTD using databuffer .Quick view am getting only one column which has M12 value aggregated.

 

QV:

 

 

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

OneStream stores every number as YTD in the database, even if you load Periodic values. What you see in that CV is the YTD value for V12, i.e. the last month of the year. Looks correct to me. If you want some other value (periodic, QTD etc), change the View member and the system will calculate it for you on the fly.