Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I have three table one is student, the second is Student register, and the third is course schedule

The field that I am trying to count is in students copy called (PAID) located towards the bottom it is a radio button. The radio button say yes paid or not paid.

The field that I need the count to be in is in the course schedule (TO) where it say registered paid this is a number field

I am trying to count how many student paid for that class so i know the count with out manually looking at each individual student. I would like the count to be in the course schedule SO WHEN I look at the class that are coming up i know how many student paid.

You can either email me at [email protected] .

CPR SAVES LIVES

Thanks

Oscar

relationships.jpg

Posted

This can be done by making RegisteredPaid a Calculation field =

ValueCount ( FilterValues ( List ( Students::Paid ) ; "Yes" ) )

However, I am puzzled by something: a student can register for a number of courses - but they either paid for ALL their courses, or did not pay at all?

See also:

http://fmforums.com/forum/showtopic.php?tid/181943/post/228583/#228583

This topic is 5378 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
×
×
  • Create New...

Important Information

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