Percentage calculation

[wonka1234]

Hi,

How can I convert my formula to a percentage?

[DataNath]

Just wrap it in ()*100, so:

([$ Difference (Attribute Abi)] / [MTD NII (IA Recalculated)])*100

If you actually want it with a % symbol then you can also use:

ToString(([$ Difference (Attribute Abi)] / [MTD NII (IA Recalculated)])*100)+'%' - for this approach, you'll need to change your output data type to a string in the formula tool.

[JamesCharnley]

Hi Wonka,

If you're just sort of looking for an aesthetic %, perhaps for a report, then I think the easiest thing to do would be to just multiply your output by 100, convert it to a string, and add a '%' to the end in a formula. If you're looking for something different then let me know. Cheers.