TOTAL and * in expression

[dafnis14]

Hi,

The following expression doesn't work for me:

sum( Qty*Carts_Per_Item) /

sum(TOTAL <Style> Qty*Carts_Per_Item)

Any idea why?

Thanks!

[sunny_talwar]

I am getting it with no problem

[dafnis14]

Hi Sunny,

I have posted the model..

Maybe I miss something silly..

Thanks for your kind help!

[dafnis14]

Please look at my model. It has dim B too..

[sunny_talwar]

You have used B as dimension, do you really need it?

[dafnis14]

Unfortunately, yes..

It has to look like that:

A	B	SUM
Cl	Bold 1	14660	33%
Cl	Regular 1	37362	33%
Fl	Smooth	10222	19%
Fl	Summer	12418	19%
Fl	Mint	8138	19%
Me	Smooth	6322	48%
Me	Bold	17352	48%
Me	Regular	52939	48%

[sunny_talwar · Accepted solution]

Try this

SUM(TOTAL <A> SUM)/

SUM(TOTAL SUM)

[dafnis14]

well, your magic touch 🙂

Thanks!

I still have to check now with multiplying by a field from another table.. so

will mark as helpful for the meantime 🙂