Arithmetic operations in a field

[Fabio Pagano]

I have a field called "Amount". I need to print a field with a value calculated on the "Amount", eg. the formula would be "Amount * 20 / 100".

So if "Amount" is 1000, the other field will print 200 (coming from 500 * 20 / 100).

Is there a way to do this, without creating a calculated column?

Thank you.

[Edward]

Hi Fabio,

Please write the following in the Text expression of the StiText component:

Code: Select all

{IIF(MyDataSource.Amount = 1000,200,MyDataSource.Amount*20/100)}

Thank you.