problem in dimension calculation

[#1]

Hii All,

I am using Add calculated dimension and providing expression as =sum({<str_coa_description={'Total Revenue','Revenue from operations','EBITDA','EBITDA Margin','PBT(before Exceptional & Extraordinary items)'}>}str_coa_description) which is giving me error in calculating dimensions.....my task is to add only these column values in dimension of straight table where str_coa_description is one of my field.

please help.

[Gysbert_Wassenaar]

You need to put an aggr around your expression: aggr( ...yourexpression..., Dim1, Dim2, ...etc). Replace Dim1, Dim2, ...etc with the other regular dimensions of your straight table.

BTW str_coa_description sounds like it's a description, not a number. Trying to sum a text field won't work.

[CELAMBARASAN]

Hi,

In dimension Direct Sum, Count functions are not allowed it should be used with the help of Aggr. Also you trying to Sum the string field(Text). Sum can be used for Numeric field

I Hope you need something like this

=Aggr(If(Match(str_coa_description, 'Total Revenue','Revenue from operations','EBITDA','EBITDA Margin','PBT(before Exceptional & Extraordinary items)'),  str_coa_description), str_coa_description)

Or simply

If(Match(str_coa_description, 'Total Revenue','Revenue from operations','EBITDA','EBITDA Margin','PBT(before Exceptional & Extraordinary items)'),  str_coa_description)

Hope it helps

[#4]

it is again giving me same problem by using aggr(), and the second method you sent giving me no value...any other way to handle it?

[CELAMBARASAN]

Could you please attach sample file.

Also could you tell me what expression you are using?