Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
How can I choose only some values (string values) from my dimension (suppose its dimension_type) of chart.
Looking forward.
Hi
=Aggr(If(dimension_type <> 'None', dimension_type), dimension_type)
=Sum({<dimension_type -= {'None'}>} ....)
HTH
Jonathan
Hi,
Thanks a lot, I used a calculated dimension and I typed this expression
=Sum({<Account_Type ={'operational_expenses'}>}Account_Type)
and syntax is correct in the editor , but when I browsed the chart ,
show me (Error in calculation dimension =Sum({<Account_Type ={'operational_expenses'}>}Account_Type)) message
can you help me please!
- you want to sum a field, that holds text values (Sum Account_Type where Account_Type = 'operational_expenses') or are those dual values?
- When using Aggregations in calculated dimensions, you have to do so using the aggr() function like
=Aggr(Sum({<Account_Type ={'operational_expenses'}>} some_numerical_field), field_to_aggregate_over)
hope this helps
regards
Marco