Urgent Help

[#1]

Hello Friends,

As I have created a expressions that is working fine but I want to add a currency symbol at the end.

like 77 666 €.

This is my expression =if(Title='Works', Sum({$<Year={$(=max(Year)-1)}>} [Amount in  Euro]),

I tried putting & '€' that is not working.

Regards

Ammu

[sujeetsingh]

just Write as {Expression} &'$'

try it

[#3]

Hi,

Thanks for your reply

As in the below I tried, no result.

=if(Title='Works', Sum({$<Year={$(=max(Year)-1)}>} [Amount in  Euro]) & '€',

Regards

Ammu

[khadeer]

Hi Ammu,

If u r using in chart go to number and select ur expression, in that number format settings, u have different options, go to money u can edit that by keeping required currency symbol.

if u r using in text box

=num("Ur expression",'$. #,##0.00;'

Hope it will works

[#5]

Hello,

You will be more efficient with the set analysis :

num( Sum({$<Title={'Works'}, Year={$(=max(Year)-1)}>} [Amount in  Euro]),'# ##0,00 €;-# #0,00 €')

Amand Dupretz

[#6]

Hi,

Thanks for your reply,

I am trying this expression in pivot table, as you said I tried, still no results.

=if(Title='Works', Num(Sum({$<Year={$(=max(Year)-1)}>} [Amount in  Euro]) ,'# ##0 €'),

Regards

Ammu

[khadeer]

If u r using in pivot table, go to number tab and left side check ur expression in right side u have number format settings, in that go to money, if there is $ u have to modify with required cureency. it definitely work .

[#8]

Hello Amand Dupretz,

Thanks for your reply, still I am unable to put a currency symbol in the expression, what you adivised is still not working and I can not use the Number format if I use the expressions will have the € symbol but I need to have only in Title One and title four.

Please adivse

=(Title='One'=Num(Sum({$<Year={$(=max(Year)-1)}>} [Freight in Euro]),'###0 €' )),

if(Title='Tow,Count({$<Year={$(=max(Year)-1)}>} Sequence),

if(Title='Three',Sum({$<Year={$(=max(Year)-1)}>}[ Weight]),

if(Title='Four',Num(Sum({$<ShipmentYear={$(=max(ShipmentYear)-1)}>}[Freight in Euro]/([Weight]/1000),'###0 € ')))))

[johngouws]

Hello Amanda,

I am not entirely sure of the solution, but recall coming across something like this before.

I think the issue is that when you place the Euro symbol after the value, it becomes text. So you may need to display the answer as text and not a 'Num' as per your set analysis.

Hopefully this can be of some assistance.

John

[khadeer]

If it possible share ur QVW file with some sample data.