philhxc Posted November 29, 2007 Posted November 29, 2007 (edited) hello everyone, I need to display the current number of active members.. i have a field "Estado" where it displays if the members is active or not... If ( Fin de Membresia ≥ Get ( CurrentDate ) ; TextColor("OK";RGB(0;128;0)) ; TextColor("NO";RGB(255;0;0)) ) i dont know if the "Socios Activos" (Active Members) can be calculated by looking up the word OK.. and then display the total number that the word OK appears on member profiles in the Estado field? all help is greatly appreciated! Edited November 29, 2007 by Guest tried to explain myself a little better
bcooney Posted November 29, 2007 Posted November 29, 2007 I prefer to create what I call a flag field for these kind of record qualifications. So, I'd change your field to: flag_StatusActive = if ( MemExpireDT >= get (currentdate); 1) this must be an unstored calc, bcs you need get (currentdate) to update. Now, create a summary field in members, TTLActive = Total of flag_ActiveStatus Unfortunately, this will be slow, because it is an unstored calc. You also can create a selfjoin relationship from members to members (cartesian) and then create an unstored calc = sum ( selfjoin::flag_ActiveStatus).
philhxc Posted November 30, 2007 Author Posted November 30, 2007 ok, i will try to do it.. lets see ho¡w it goes thanks!
philhxc Posted December 18, 2007 Author Posted December 18, 2007 cant get it to work, nothing shows up on the fields... what could be the problem?
bcooney Posted December 18, 2007 Posted December 18, 2007 I'll need some more detail to help. When you say, nothing shows up on the fields, which fields? What did you create? Any of the fields that I recommended? Can you post a copy?
Recommended Posts
This topic is 6245 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