Jump to content

Self-Join Portal?


JustJoker
 Share

This topic is 4407 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4407 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.