6 Replies Latest reply: May 19, 2018 1:18 PM by dhasharadh goud RSS

    urgent help required to find the avg consumption..??

    dhasharadh goud

      Hi All need urgent help on the below.

       

      we have to calculate the average but my results are at sub key level..

       

      we have to avoid sub key level and calculate the avg on the top of it..

       

      formula given in requirement doc :

       

      = (NUM_OF_FULLY_CONSUMED * NUM_DAYS) / SUM(NUM_DAYS) WHERE NUM_OF_FULLY_CONSUMED != 0

       

      current avg formula : (which is at sub_key level)

       

      if (SUM_OF_FULLY_CONSUMED <> 0 , (NUM_OF_FULLY_CONSUMED * NUM_OF_DAYS) ) as AVG_DAYS_SUM

       

       

      chart exp : Sum({<PASS_TYPE={LTE}>}AVG_DAYS_SUM) / Sum({<PASS_TYPE={LTE}>}NUM_OF_DAYS)

       

      new formula am looking for : (with avoiding sub_key)

       


       

      can any please help me how to wirte this set expression by avoiding SUB_KEY and by including above current avg formula and chart ext...bit urgent please