expressn

[raadwiptec]

i have a tricky situation where i need to sum diffierent values in expression

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'CRKNM'}  >}Amount_Euro)

+

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'LMGCR'}  >}Amount_Euro)

+

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {';KOPDD'}  >}Amount_Euro)

the above is not working...any suggestion

[m_woolf]

If you are getting a null result, it could be because one of the three sub expressions is null.

try using Rangesum:

Rangesum(sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'CRKNM'}  >}Amount_Euro),sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'LMGCR'}  >}Amount_Euro).sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {';KOPDD'}  >}Amount_Euro))

[Anonymous]

Hi Raad,

In the 3rd set expression please remove the semicolon before the Entity value. Entity = {';KOPDD'}  The expression would be like below,

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'CRKNM'}  >}Amount_Euro)

  +

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},[Code] = {'91'},Entity = {'LMGCR'}  >}Amount_Euro)

  +

sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {'KOPDD'}  >}Amount_Euro)

Thanks,

Sarat.K

[vishsaggi]

Why don't you use Entity only once like below:

= sum({<Source={'SAP'}, Category = {'Finance'},Object = {'23'},

 = {'91'},Entity = {'CRKNM', 'LMGCR', 'KOPDD'}                 >}Amount_Euro)