AnsweredAssumed Answered

Case/Let/If Calculation Help

Question asked by adhutchinson on Feb 20, 2018
Latest reply on Feb 20, 2018 by philmodjunk

Hi Everyone,

I've been stuck on this one for a while now... Hoping someone might be able to help.

 

I have a membership database, where the members status is based on the payments made against their registrations.

 

I want it to check the variables as listed, and then spit out one of the options;

  1. Check Member has a registration in that current year (all records in the table are sorted by a descending date);
  2. Check if Member owes against their registration in current year;
  3. Checks if Member has any outstanding registration payments from previous years;
  4. Spits out one of the following values;
    1. Active - Registered Current Year & All Paid Up
    2. Payment Pending - Registered Current Year & Not Fully Paid
    3. Unfinancial - Registered Current Year but has outstanding payments from previous years
    4. Archived - Not registered in current year and no outstanding debts

 

Example Below:

Let ( [

datecheck = Year ( Registrations::Date ) = Year ( Get ( CurrentDate ) ) ;

var_active = Round ( Registrations::fin_Variance ; 2 ) = 0 ;

var_paypend = Round ( Registrations::fin_Variance ; 2 ) > 0 ;

due = GetAsNumber ( Registrations::due_Since ) > 90 ] ;

 

Case (

datecheck and var_active ; "Active" ;

datecheck and var_paypend ; "Payment Pending" ;

due and var_paypend; "Unfinancial" ; "Archived" ) )

Outcomes