Calculation Field in a portal not working properly

[amontague]

I'm working on a simple Invoicing database with a line items table and an Invoices table. In the line items table I have a Calculation field called "formatted_time" that formats the time spent on a job. For example, if I spend 69 minutes on a job the "formatted_time" field shows "1 hour 9 mins". This works as expected in the line items table.

However, when I put a portal in the Invoice table the calculated "formatted_time" field doesn't work properly. If there is only one line item in the portal - the formatted time works as expected. But if there are two line items the "formatted_time" doesn't show properly. Each "formatted_time" field shows "1" - no matter how many hours or minutes were worked.

Seems a strange one to me. Anyone any ideas where I'm going wrong? I know for print-outs I should be working from the line items table - but that's another day's work.

Regards

Andrew

[Sanjai]

Try keeping the field "formatted_time" inside the portal tool. I have faced a similar problem where the calculation result shows "1" but when I kept the field inside the portal tool in a portal row, it worked fine.

[Osman]

Problem may be caused because of sellecting field from different relation, not same as portal's relation.

Adam Djuby

[amontague]

Ok, I've made a little bit of progress. The problem is to do with the relationships between the tables. I have two instances of the line items table in the relationship graph. If I base the portal on line items 1, the formatted_time comes out correctly, but the description and price are the same for every row. If I base the portal on line items 2, the formatted_time is the same for every row, but the description and price is correct.

I've obviously got problems in my relationship graph that I'm going to try and sort out.

Thanks for your help.

Andrew