8 Replies Latest reply: Oct 12, 2011 11:03 AM by 894127 RSS

    Bi publisher: calculation with SUM

    802044
      Hi,
      I'm trying to put the next formula in my rtf tmeplate: (SUM(UNT_TAKEN x GRADE_OFF)/SUM(UNT_TAKEN if CREDIT_EARNED='Y') * 5

      I tried to resolve it with the following expression:

      <?(sum(current-group()/UNT_TAKEN[.!=]*GRADE_OFF[.!=])div(sum(current-group()[CREDIT_EARNED='Y']/UNT_TAKEN)))*5?>

      but I get an error.

      Can anyone help me with this problem?

      grtz