Calculating rates!

[fernanda]

Hi!

I have a report with 3 columns: "client", "paid ammount" and "to pay ammount".

Imagine something like this:

Client | Total amount | Paid amount
________________________________________
1 | 100 | 15
2 | 200 | 25

Can I, at report time, add a column containing "To pay amount" / "Paid amount" ??

I would have something like

Client | Total amount | Paid amount | New column
______________________________________________________
1 | 100 | 15 | 0.15
2 | 200 | 25 | 0.125


Thxs

fernanda

 

[blom0344]

Hello Fernanda,

Create a new variable:

New Column = <Paid Amount>/<Total amount> by choosing Data --> variables from the menu. Now insert a column to the right of your table and assign the new variable to the body-part of this column. BO will automatially assign the name of the variable as a header to the column.

These basic skills are excellently documented in the report manual that comes as a pdf document as an option when you install the client. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com