Calculations using Text box

[#1]

Dear All,

I was trying to show the percentage difference via text box. But it appears like 24.657345. How can I Make it a whole number in Text box  or should I use some other object for the same

and How should I add % sign after my whole number?

Thanks in advance !!!

Regards

Anjana

[#2]

try this

=num(yourexpression,'##.##%')

for eg:

=num(Avg(sales),'##.##%')

[danieloberbilli]

try

=num(24.657345 / 100, '0%')

[Anonymous · Accepted solution]

Hi,

You should put it like this in the text-field :

=Num([SKU Length]/[SKU Height],0) & ' %'

where [SKU Length] / [SKU Height] is your calculated field.

When you put it like this :

=Num([SKU Length]/[SKU Height],0.00) & ' %'

you get 2 digits after the decimal sign.

Paul

[#5]

=num(Expression,'#,##0.00%')  this will give you 2 decimal..

The Expression output is already a percentage value the you have to concatenate %

like this

=num(Expression,'#,##0.00') &'%' this will give you 2 decimal..

[manideep78]

Hi Anjana

Try this in you Text Object

=Round(<Your Difference Expression>) &'%'

Eg.  =Round(12.3456-7.2568) &'%'  =  5%

Hope this Helps

Regards,

Manideep

[Anonymous]

Hi,

Just forgot to mention, this way of listing things is possible in all text-fields. I use it a lot in the titles of a table or chart. The great advantage of this is that the user can leave the table minimized and still see the endresult and don't have to open the whole table (sometimes slow) to see the same percentage (or total).

An other small tip,  with  chr(10) you can force a line feed. So with

='Length : ' & [SKU Length] & chr(10) & 'Height : ' & [SKU Height]

you get 2 lines like this :

Length : 4.235

Height : 1.125

Thanks for the credit 

Paul