0 Replies Latest reply on Aug 12, 2013 9:47 AM by Venkatesh Nagarajan

    Calculated field along with others.

    Venkatesh Nagarajan

      Hi all,

      I have the following. I want to layout A, B and difference of A&B (ie A-B) on 3 columns. I have calculated a new field that is A-B. But how can I layout all 3 of the them, A, B and my new calculated field.

      Thanks

      Venkat

      ScenarioRegionDepartmentSubDepartmentDateRevenueExpenses
      AR_NORTH_AMERICAMI6/1/2013                          638                      129
      AR_NORTH_AMERICAMI6/2/2013                 605,978                12,137
      AR_NORTH_AMERICAMI6/3/2013                    58,892                      324
      AR_NORTH_AMERICAMI6/4/2013                    56,839                43,565
      BR_NORTH_AMERICAMI6/1/2013                    63,829                           5
      BR_NORTH_AMERICAMI6/2/2013                      6,059                  8,765
      BR_NORTH_AMERICAMI6/3/2013                      5,889                        65
      BR_NORTH_AMERICAMI6/4/2013                          568                        65