Sum Total Conditional

[#1]

Hi,

I am trying to write a formula to calculate Market Share:

sum(if(Condition=1,Units))/sum(Total{<Condition={1},competitor>}Units)

The first part of formula(Numerator) is working. However when i use total condition in next part(denominator) it fetches no result. How can i modify the same to apply both condition?

Thanks.

[alexandros17]

Try This:

sum(if(Condition=1,Units))

/

sum({$ <Condition={1},competitor=>} Total Units)

... and let me know

[sujeetsingh]

Try removing the total

[maxgro]

sum( {$ <Condition={1}>} Units)

/

sum({$ <Condition={1},competitor=>} Total Units)

[#5]

It doesn’t work ☹

[#6]

It doesn’t work ☹

[alexandros17]

... so explain better what is your aim:

why do you use competitor field only in the denominator? Try with this expression for the denominator

sum({$ <Condition={1}>} Total Units) ... if it works you have to understand the problem related to competitor.

Hope it helps

[#8]

The first part of formula works. I am using competitor in the denominator because i want to total the unit sales competitor wise.

[alexandros17]

Ok, then try the expression for the denominator without competitor as I suggested in the previous message and let me know