Set Analysis

[MK_QSL]

Using below set expression, I am getting the correct result...

Just want to know, is there any merged/shorter version of this expression possible?

=SUM({<Brand = {'B1','B2'}, Type = {1}>}Sales)

+

SUM({<Brand = {'B3'}, Type = {3}>}Sales)

+

SUM({<Brand = {'B4'}, Type = {2}>}Sales)

[#2]

Hi,

U can try this one

=Sum( {<Brand = {'B1','B2'}, Type = {1}>  + <Brand = {'B3'}, Type = {3}>+<Brand = {'B4'}, Type = {2}> } Sales)

Regards,

Vivek

[kalyandg]

hi Manish,

you can try this

=sum({<Brand={'B1', 'B2', 'B3', 'B4'}, Type={'1','2','3'}>}sales)

Best Regards,

Kalyan.D

[tresesco · Accepted solution]

This?

=SUM({<Brand = {'B1','B2'}, Type = {1}> + <Brand = {'B3'}, Type = {3}> + <Brand = {'B4'}, Type = {2}>}Sales)

[MK_QSL]

So Simple... How come I haven't think about it?

[MK_QSL]

What if ?

=SUM({<Country = {'UK'}, Brand = {'B1','B2'}, Type = {1}>}Sales)

+

SUM({<Country = {'UK'}, Brand = {'B3'}, Type = {3}>}Sales)

+

SUM({<Country = {'UK'}, Brand = {'B4'}, Type = {2}>}Sales)

Question is Can we make Country = {'UK'} common or need to mention everywhere

[tresesco]

May be this?

=SUM({<Country = {'UK'}>* (<Brand = {'B1','B2'}, Type = {1}>+ <Brand = {'B3'}, Type = {3}>+< Brand = {'B4'}, Type = {2}>)>} Sales)

[MK_QSL]

Giving syntax error!

[tresesco]

This?

=SUM({<Country = {'UK'}>* (<Brand = {'B1','B2'}, Type = {1}>+ <Brand = {'B3'}, Type = {3}>+< Brand = {'B4'}, Type = {2}>)} Sales)

Removed an extra '>'