Help with Text String to display % and two decimal places

[#1]

Hi

Please assist with Text String. I need this text object to display value as % with only 2 decimal places.

='Growth%:  ' & (100*(Sum(Sales14)/Sum(Sales13)-1))

Can someone assist?

[sunny_talwar]

Try this:

='Growth%:  ' & Num(Sum(Sales14)/(Sum(Sales13)-1)*100, '#.00%')

='Growth%:  ' & Num((Sum(Sales14)/Sum(Sales13)-1)*100, '#.00%')

='Growth%:  ' & Num((Sum(Sales14)/Sum(Sales13)-1), '#.00%')

[maxgro]

='Growth%:  ' & num(Sum(Sales14)/Sum(Sales13)-1, '#.##0,00%')

maybe you have to change .,

- when you have an expression

Sum(Sales14)/Sum(Sales13)-1

and want to format (in a textbox)

- add num to your expression for formatting

num(expression, 'format')

and choose the format in number tab (chart or listbox)

num(expression, '#.##0,00%')

[sasiparupudi1]

='Growth%:  ' &  num(Sum(Sales14)/Sum(Sales13)-1) , '#.##%')

[qlikviewwizard]

Hi,

Please use this:

='Growth%:  ' & Num((100*(Sum(Sales14)/Sum(Sales13)-1)),'###,##.00')

[#6]

Thanks Sunny, very helpful. I also dropped the *100 after getting the Expression OK.

Appreciate the help and this forums will go a long way to upping my skills.

Thanks all

[mohammadkhatimi]

Hie..

='Growth%:  ' &  num(Sum(Sales14)/Sum(Sales13)-1) , '#.#0%')

or

do it from

Properties-> Number tab->Fixed to(How much digit you want) and check the Show in percentage checkbox...

Hope this will helps you..!!

Regards,

Mohammad