Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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) & '%'
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...
yes value is numeric
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], '##'))
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
Try this ...
IF(field = 123, SUM(amount)*100) & '%'
No I cant use this as I ma using big nested if
Remove *100 from expression and use below...
NUM(
Your Big Expression i.e. Nested If
,'#,##0%')
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