The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Fh1's avatar
Fh1
New Contributor
2 years ago

How to calculate values of the same column in the Calculated Field

  Good morning, I am writing to inquire about the correct formula for calculating the difference between two values in the same column in a Calculated Field of a Report Design. For example, if ...
Cube View
dashboards
Reports
Sai_Maganti's avatar
Sai_Maganti
Contributor II
2 years ago

You might want to try this:

Create 3 calculated Items

Item1
iif(Col1Hdr0NameAndDesc = 'Some Val', SUM(Col0Value), 0)

Item2
iif(Col1Hdr0NameAndDesc = 'Some Other Val', SUM(Col0Value), 0)

Item3 = Item1 - Item2

  • Fh1's avatar
    Fh1
    New Contributor
    2 years ago

    Thank you Sai_Maganti