1 Reply Latest reply: Feb 13, 2013 10:58 PM by Srini VEERAVALLI RSS

    RSUM in rpd

    Khadka
      I was trying to calculate running sum as Rsum("Sales Amt LY" by "Month" ), it throws error as [nQSError: 27002] Near <by>: Syntax error [nQSError: 26012] . . But when i tried the same thing in obiee 11.1.1.5 answers it is working fine.

      How to make logical column with Rsum("Sales Amt LY" by "Month" ) in rpd. Please suggest some solution.
        • 1. Re: RSUM in rpd
          Srini VEERAVALLI
          Running aggregates are top of result set, you may not do it same way in rpd as you do in answers, correct me if I'm wrong.

          If at all you want to go with rpd then try this way; Use
          Rsum("Sales Amt LY") and set this to "Month" level at content tab. Results might vary when you compare rum using answers and vs. rpd

          If helps mark.

          Edited by: Srini VEERAVALLI on Feb 13, 2013 10:57 PM