JustJoker Posted January 13, 2011 Share Posted January 13, 2011 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 More sharing options...
comment Posted January 13, 2011 Share Posted January 13, 2011 Why not use summary fields? Link to comment Share on other sites More sharing options...
JustJoker Posted January 14, 2011 Author Share Posted January 14, 2011 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 More sharing options...
comment Posted January 14, 2011 Share Posted January 14, 2011 Sum() and Count () are aggregate functions. Summary fields are something else: http://www.filemaker.com/11help/html/create_db.8.16.html#1029235 Link to comment Share on other sites More sharing options...
JustJoker Posted January 14, 2011 Author Share Posted January 14, 2011 Thank you VERY MUCH Missed that. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4822 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 accountSign in
Already have an account? Sign in here.
Sign In Now