Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
10 months ago

Balancesheet Period DataLoad

Hi All - I have a quick question on Periodic Data Load for Balance Sheet. If I load Periodic data to BS accounts, will it calculate YTD automatically? or we need to write a formula to get the YTD value. Any Input would be appreciated ?

Thanks

 

 

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    All data in OneStream is always stored as YTD, even if you enter it as Periodic; so the answer is yes, if you're using standard Import profiles all YTD values will be automatically calculated.

    The only exception to this rule is BiBlend.

    • Krishna's avatar
      Krishna
      Valued Contributor

      Thanks JackLacava - I wanted to make sure you that I understand correctly, without any configuration in OS the below illustrations are correct. See the image below

       

       

      • JackLacava's avatar
        JackLacava
        Honored Contributor

        Yes that's what you would expect in the database.