9 Replies Latest reply: Mar 6, 2017 11:06 AM by Sunny Talwar RSS

    witch formula for doing that

    Do espirito Arnault

      hi,

      i have 3 dimensions and datas :

       

      cost_center, nbex, nbdays

      103601, 178359, 26

      103602, 73557, 26

      103603, 70689, 26

       

      in a formula, i want to calculate the average nbex per day :

      178359/26 + 73557/26 + 70689 / 26

      that is : 6859 + 2829 + 2719 = 12407

       

      of course sum(nbex) / sum(nbdays) doesn't work.

       

      could anyone help me ?

      thank you very much.