AVG on formula

[Anonymous]

I have a formula field  that looks like this “sum(a)+sum(b)/sum(c)”

I need to do avg on this formula without changing the field formula.

Tried avg(formula) it didn’t work. Any ideas ??

[ariel_klien]

Hi,

Try to do this on the script level like:

Load ...

        sum(a)+sum(b)/sum(c) as formula

from....

and in the expression put avg(formula)

BR

Ariel

[whiteline]

Hi.

Avg() means that you have a set of results of your formula. Suppose that you want to get the average of  a set that is provided by dimension Dim. Then you could write an expression:

=avg(aggr(fourmula, Dim))

[Jason_Michaelides]

Have you tried Avg((a+b)/c)?

[rajeshvaswani77]

Have you missed out the brackets in your formula?

(sum(a)+sum(b))/sum(c)

thanks,

Rajesh Vaswani

[lironbaram]

hi as far as i know

if you want to do an average on sum function you need to define the dimension on which you calculate the average

let say you want to do average for customer then you'll expression will look

avg(aggr(Formula,Customer))