Hello!

I'm getting into FM and can't manage to solve a simple (at least in Access and Excel it was) task.

I've got a table:

ID_Transaction

Some other fields...

Profit_or_Loss (calculated 1 or 0)

I need to calculate the Sum() and Count() of Profit_or_Loss in this table to find a proft/loss ratio.

As I understood, it should be possible to make with a self-join relation and portal of the same table. But I can't place such portal on layout. All fields and options in portal's dialog box are locked.

Could somebody help me, please?

Sergey

Why not use summary fields?

Thanks for the reply.

Results of Sum() and Count () in the table just calculate one field. For example, Profit_or_Loss fields in the table where calculations added contains 1 or 0. The result of Sum() in every field is 1 or 0. The result of Count() -- 1 in every field. That's why I've thought about adding that Sum and Count in separate related table. I think I'm doing smth wrong.

Please help the novice (me).

Sum() and Count () are aggregate functions. Summary fields are something else:

http://www.filemaker.com/11help/html/create_db.8.16.html#1029235

Thank you VERY MUCH

Missed that.