HOW TO CALCULATE PERCENTAGE?

[sushil353]

HI, Experts

i am facing problem while calculating percentage. i have two fields TOTAL_UNIT_PASSED AND TOTAL_UNITS_PROCESSED and i want to calculate the percentage (TOTAL_UNIT_PASSED/TOTAL_UNITS_PROCESSED *100). but i am getting result only 100 and how to aply % symbol.

Please help me.......

Thanks

[IAMDV]

TOTAL_UNIT_PASSED / TOTAL_UNITS_PROCESSED & ' %'

Use this expression and change the format in the NUMBER tab. Check the option Show in Percentage%.

Cheers - DV

[#3]

you could use the following if it's a text box:

NUM( TOTAL_UNIT_PASSED / TOTAL_UNITS_PROCESSED , '###.00%' )

you can decide if you want the decimals or not

Jon

[sushil353]

THANKS JON

[IAMDV]

Sushil - Please can you mark on answered on Jon's post.

Thanks,

DV