Adding % symbol after calculated value in expression

[#1]

Hi,

We have calculated value by using one IF expression lets say the valu is xyz and we just need to add '%'
symbol after that value like xyz% but when we try to use &'%' in then statement of IF condition it doesnt work. Kindly suggest alternatives.

[juleshartley]

Hi,

Are these numeric values? If so then you may need to convert to text in order to add % to some of them. Try this:

text(xyz) & '%'

[juleshartley]

PS: If they are numeric fields, then I'd always recommend handling the formatting in the front end and retaining the data as a decimal...

[#4]

yes value is numeric

[juleshartley]

So where are you doing this formatting? You should be able to use something like this in an expression:

If ([field]= 123, num([field], '##%'), num([field], '##'))

[#6]

Sorry but its not working, If I append this before the value its working, like

if ([field] = 123, '%'&(sum(amount)*100) , '')-- its working

but

if ([field] = 123, (sum(amount)*100) &'%', '') -- this is not working

[MK_QSL]

Try this ...

IF(field = 123, SUM(amount)*100) & '%'

[#8]

No I cant use this as I ma using big nested if

[MK_QSL]

Remove *100 from expression and use below...

NUM(    

     Your Big Expression i.e. Nested If

,'#,##0%')

[christian77]

Hi.

Formating it's only a view. It keeps numbers in memory as they are, but it represent them with a format.

The best thing to do about it is to copy formats from the tab Number in objects or in document properties.

luck