Self-Join Portal?

[JustJoker]

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

[comment]

Why not use summary fields?

[JustJoker]

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).

[comment]

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

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

[JustJoker]

Thank you VERY MUCH

Missed that.