Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Feb 17, 2009 10:16 am**

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.

Posted: **Tue Feb 17, 2009 10:28 am**

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.

Creating reports and dashboards | Stimulsoft community forum

Arithmetic operations in a field

Arithmetic operations in a field

Arithmetic operations in a field