3 Replies Latest reply: Feb 1, 2013 4:00 AM by Rod West RSS

    Explanation of formula? - Oracle BI Discoverer


      Please can someone explain the following formula:

      DECODE(NVL(FTE Days Available SUM,0),0,0,FTE Days Absent SUM/FTE Days Available SUM)

      I have looked up the DECODE and NVL functions and I believe I understand them.
      However the way that the formula is wrote for the following: NVL(FTE Days Available SUM,0) - I think the values are summed before they are checked if they are null. - Is this correct?

      Thank you.