2 Replies Latest reply: Jun 11, 2012 8:59 AM by 818523 RSS

    Formula

    818523
      I've seen below formula in a report. What does it mean? Is it Oracle BIEE syntax?


      table."os" / sum(table."os" by period."month end date")

      Thanks,
      tedphy
        • 1. Re: Formula
          Luko
          Hello,

          This is ratio of the "transaction" amount to the all amount of the last day in month. If you multiply by 100 or give percentage format you will have percentage transaction share of all amount of the last day.

          Translation 10:

          all translation in last day 100

          You have 10%


          http://gerardnico.com/wiki/dat/obiee/group_by


          check Alternative Syntax : the BY clause

          Regards,
          Luko
          • 2. Re: Formula
            818523
            Thank you for your information. It is very helpful