1 Reply Latest reply on Dec 16, 2016 1:23 AM by Sreekanth Kasaraneni

    Divide two columns of LOD calcualtions

    Evan Campbell

      I have a table a values made up of "YEAR", "Software Cost" and "Research Cost".

       

      The "Software Cost" and "Research Cost" are filtered for each year from their respective dimensions.

      I am using the Level of Detail expressions for each column:

           { FIXED [SYSTEM], [Year (Date Data Type)]: SUM([Planned Cost ]) }

           { FIXED [APP], [Year (Date Data Type)]: SUM([Planned Cost ]) }

      Where I later filter in "SYSTEM" for "Software Cost"; and I filter in "APP" for "Research Cost".

       

      Now I would like to divide these values. Is that possible?

       

      Thanks!