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]

Would you be able to post a sample?

[Miguel_Angel_Baeyens]

What do you mean by "it does not work"? Syntax seems to be OK, if it does not return the results you expect then as Sunny suggests post some sample data and expected results.

Are Qty and Carts_Per_Item fields in the same table?

[dafnis14]

Will try..Thanks!

[dafnis14]

Hi,

My issue is somewhere else:

I would like to have the relative quantity by dim A,

or share of A

SUM(SUM)/ SUM(TOTAL <A> SUM)

A	B	Qty	%	Total by A
		159413	100.00%	100%
Cl	Bold 1	14660	9.20%	28%
Cl	Regular 1	37362	23.44%	72%
Fl	Mint	8138	5.10%	26%
Fl	Smooth	10222	6.41%	33%
Fl	Summer	12418	7.79%	40%
Me	Bold	17352	10.88%	23%
Me	Regular	52939	33.21%	69%
Me	Smooth	6322	3.97%	8%

Desired number:

Cl	52022	32.63%
Fl	30778	19.31%
Me	76613	48.06%

What am i doing wrong??

Thanks!

[sunny_talwar]

May be you need this

Sum(SUM)/Sum(TOTAL SUM)

[dafnis14]

Hi,

Yes, in my original model the 2 fields are in different table.

Could that cause an issue?

I simplified it just to check in the above data (sum by dim A), but it doesn't work either,,

Thanks!

[dafnis14]

No, it gives the same result as the % column..

[dafnis14]

Just Attached the data..

[sunny_talwar]

This is what you want to get, right?

I guess create a chart with

Dimension

A

Expression

Sum(SUM)

Sum(SUM)/Sum(TOTAL SUM)

This doesn't give you what you want, really?