Divide 2 fields

[#1]

Hi,

I have a script consisting of several joins. I want to add a calculated field in the end, where I devide the value of 2 fields. My problem is that when deviding the key field is not taken into account. See attached file.

I would expect a result with 3 rows - one row for each article. Please help.

[swuehl · Accepted solution]

I think you need to use the Article field in your last left join:

left join (Data)

load Article,

    Qty/BoxSize as NumberBoxes

Resident Data;

[#3]

Use resident load, see attached