8 Replies Latest reply: Jan 20, 2014 5:36 AM by Alessandro Saccone

Sum Total Conditional

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.

• Re: Sum Total Conditional

Try This:

sum(if(Condition=1,Units))

/

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

... and let me know

• Re: Sum Total Conditional

Try removing the total

• Re: Sum Total Conditional

It doesn’t work ☹

• Re: Sum Total Conditional

It doesn’t work ☹

• Re: Sum Total Conditional

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

/

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

• Re: Sum Total Conditional

... 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

• Re: Sum Total Conditional

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

• Re: Sum Total Conditional

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