topic Re: Calculation of market share in App Development

Calculation of market share

ecabanas — Wed, 08 May 2019 11:22:05 GMT

Hi,

I would like to calculate the number of units Vs the category. for example

(sum(unit_quantity*quantity_delivered) / Sum({<[Subcategory2]={GetFieldSelections(Subcategory2)}>} unit_quantity*quantity_delivered))-1

If I select my brand XX who's is in the Subcategory2: cookies

I would like to calculate the amount of "my" cookies (because I selected my brand in the brand list) Vs the amount of all cookies (that has not been selected in any Subcategory2 List)

Thank's for your help

Re: Calculation of market share

Anil_Babu_Samineni — Wed, 08 May 2019 11:37:32 GMT

Perhaps just this?

(sum(unit_quantity*quantity_delivered)
/
Sum({<[Subcategory2]=P(Subcategory2)>} unit_quantity*quantity_delivered))-1

Re: Calculation of market share

sunny_talwar — Wed, 08 May 2019 11:38:47 GMT

Try this

(Sum(unit_quantity * quantity_delivered) / Sum({<[Subcategory2] = P([Subcategory2]), Brand>} unit_quantity * quantity_delivered)) - 1

Re: Calculation of market share

ecabanas — Wed, 08 May 2019 14:32:26 GMT

Hi all

This formula did not works, I did the manual calculation to show what I'm looking for,

Thank's for your help again

thank you guys

Re: Calculation of market share

sunny_talwar — Wed, 08 May 2019 14:42:53 GMT

Try this

Sum(unit_quantity * quantity_delivered) / Sum(TOTAL <Category> unit_quantity * quantity_delivered)

Re: Calculation of market share

ecabanas — Wed, 08 May 2019 15:20:41 GMT

Hi Sunny,

Thank's for your patience.

I've isolated the denominator, and I play with the selectors to see how the amount changes (which it shouldn't) and if it changes when I change the selectors. If I select a name, brand, this amount changes but should not, I need to know the units of the total of the category

If I apply a condition like Brand=, EAN= the problem is that if I include this formula the table shows the rest of selections

Re: Calculation of market share

sunny_talwar — Wed, 08 May 2019 15:26:41 GMT

Use if statement my friend

If(WeightSold Expression <> 0, Weight Sold Category Expression)

Re: Calculation of market share

ecabanas — Wed, 08 May 2019 15:45:07 GMT

I put this if statement in the expression and eliminate all the dimensions and I only left one (name)

If(Sum( {<name=>}TOTAL <SubFamilia2> unit_quantity * quantity_delivered) <> 0, Sum( {<name=>}TOTAL <SubFamilia2> unit_quantity * quantity_delivered))

But the result is the same

Re: Calculation of market share

sunny_talwar — Wed, 08 May 2019 16:15:48 GMT

No idea what you want. You keep on changing the requirement description with each post. Can you please clearly state what you have and what you want?

Re: Calculation of market share

ecabanas — Wed, 08 May 2019 16:26:08 GMT

Hi sunny

Yes is very clear what I'm looking for:

This calculation, independently in the denominator the selections. Only care the category selected to know the number of units that the category has

If I select two units from a category, how could I know the number of units that this category has (all the units, not only the selected)

Thank's

Re: Calculation of market share

sunny_talwar — Wed, 08 May 2019 16:39:55 GMT

Sorry my friend, I don't understand... may be someone else can help.