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

# witch formula for doing that

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.

• ###### Re: witch formula for doing that

Try this

Sum(nbex/nbdays)

• ###### Re: witch formula for doing that

ok thank you,

i have set analysis for each part :

sum({<RATIO={'EXPOR'}>} REEL_RAT)/sum( {<RATIO={'NBPAR'}>} REEL_RAT)

how to transform in Sum(nbex/nbdays) ?

• ###### Re: witch formula for doing that

May be this:

Sum({<RATIO={'EXPOR', 'NBPAR'}>}nbex/nbdays)

• ###### Re: witch formula for doing that

REEL_RAT contains nbex with set analysis {<RATIO={'EXPOR'}>}

and nbdays with set analysis {<RATIO={'NBPAR'}

so it's difficult to do this

• ###### Re: witch formula for doing that

Do you have a sample where you can share? Without knowing your data, it would be difficult for me to propose anything here

• ###### Re: witch formula for doing that

thank you

here is my exemple,

i want 12407 and not 4136

• ###### Re: witch formula for doing that

Try this:

='wrong total : '&num(Sum(Aggr(Sum({<RATIO={'EXPOR'}>} REEL_RAT)/sum( {<RATIO={'NBPAR'}>} REEL_RAT), COST_C)),'# ##0')