Expressing calculation result as a percentage

[Nickolay]

Is it possible to express result of a calculation as a percentage value? For example, if division is used: 2:5=0.5 to show it as 50%. I am aware that % sign can be added via concatenate. But is there an easier way of doing it?

[Sebastiaandb · Accepted solution]

Hi @Nickolay ,

Way i normally get that % value is just making a string field out of it like:

:-)

Edit after reply of @DataNath ... i'm so lazy haha ;-) added the *100, thanks for pointing it out mate!

Here's the formula:  tostring(([Field1]/[Field2])*100)+"%"

Greetings,

Seb

[DataNath]

Unfortunately not whilst keeping a numeric data type or anything. The best way to go about this is do what @Sebastiaandb has done and calculate the value whilst turning it into a string before adding %. Just be careful - you need to multiply that result by 100 to get it as a true percentage:

[gautiergodard]

hey @Nickolay 

I agree with @Sebastiaandb on this one. 

Another quick way to do it if you are you going to be outputting your results using a table tool from the reporting pallet is by using the prefix functionality shown below.

[Nickolay]

Thanks a lot all! It works for me 😀