Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try This:
sum(if(Condition=1,Units))
/
sum({$ <Condition={1},competitor=>} Total Units)
... and let me know
Try removing the total
sum( {$ <Condition={1}>} Units)
/
sum({$ <Condition={1},competitor=>} Total Units)
It doesn’t work ☹
It doesn’t work ☹
... 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
The first part of formula works. I am using competitor in the denominator because i want to total the unit sales competitor wise.
Ok, then try the expression for the denominator without competitor as I suggested in the previous message and let me know