Forum Discussion

RoulaHabbal's avatar
RoulaHabbal
Qrew Cadet
4 months ago
Solved

Formula-Numeric Field Returning Null Instead of 0

Hello: My current formula-numeric field returns null, instead of 0. How could I tweak the formula below to return 0?  Please note: A. The numeric fields below have the "treat blank values as ''0'...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    4 months ago

    Try this

    var number AssociatesDegreeScore = If([GPA - Associate Degree]>=3.3, 2,0);
    var number BachelorsDegreeScore = If([GPA - Bachelor's Degree]>=3.3, 3,0);

    var number FinalScore = If(
       [GPA - Bachelor's Degree]>0, $BachelorsDegreeScore,
       [GPA - Associate Degree]>0  , $AssociatesDegreeScore,
        0
    );

    If([Primary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)" or [Secondary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)", $FinalScore)*1.5

     

     

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 months ago

Try this

var number AssociatesDegreeScore = If([GPA - Associate Degree]>=3.3, 2,0);
var number BachelorsDegreeScore = If([GPA - Bachelor's Degree]>=3.3, 3,0);

var number FinalScore = If(
   [GPA - Bachelor's Degree]>0, $BachelorsDegreeScore,
   [GPA - Associate Degree]>0  , $AssociatesDegreeScore,
    0
);

If([Primary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)" or [Secondary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)", $FinalScore)*1.5

 

 

  • RoulaHabbal's avatar
    RoulaHabbal
    Qrew Cadet
    4 months ago

    Good morning, Mark.

    That did it.

    Thank you very much for your help. I appreciate it.

    Roula