Header issue

[arusanah]

I am using this  expression in my report

Num(SuM(Fact.CustomerSales*([CurrencyConversion.EUR - Budgeted Rate CFY])))/1000

while it executes the expression , i get " Garbage after EUR" as header .

Any Idea what could be the reason?

[maxgro]

2 fields?

[CurrencyConversion.EUR - Budgeted Rate CFY]

[CurrencyConversion.EUR] - [Budgeted Rate CFY]

[arusanah]

no Massimo

[CurrencyConversion.EUR - Budgeted Rate CFY]

this one field coming from Currency table.

[ziadm]

hi

whta is Fact.CustomerSales is this a function or Selection state ?

[danieloberbilli]

Could it be that the 'EUR' in the error message is due to a mistake in another expression/dimension/condition where 'EUR' appears?

If this expression is the only possibility, it means that the field [CurrencyConversion.EUR - Budgeted Rate CFY] is not identified as such. e.g. if you use the field name in a variable you have to ensure that the [ ] are set in a proper way 

[arusanah]

EUR is value in Currency Dimension in data model. But why would it give error in Report Header.

[arusanah]

In Fact table there is a field CustomerSales . and since Fact table uses qualifiers i.e y the field is Fact.CustomerSales

[danieloberbilli]

what do you mean with 'Report' header? is it the title in the caption of a chart object?

[jonathandienst]

I can't replicate your error - a small test model handles that expression in a table or a text box without a problem. I suggest that you post a sample model to investigate further.

BTW the Num() in that expression is redundant.

[#10]

Hi Archana,

You can try this.

=Num(SuM(Fact.CustomerSales) * sum(([CurrencyConversion.EUR] - [Budgeted Rate CFY])))/1000