I have a portal that filters records for students absences. Two fields that are important are "Credit" and "Abs_count"

Credit is either 1 or .5

Abs_count is the total absences over a certain allowed amount.

1 credit = you are only allowed 18 absences

.5 = you are only allowed 9 absences

I am trying to do a calculation that will look at the credit field and see if it is "1" or ".5" then take the appropriate number either "18", "9" and subtract from the total abs_count.

I have looked a IF statements and Case and having a problem with both. I made a field called "MakeUpHours"

Case (

Get ( Credit ) = 1

- (abs_count) = Sum



Get (Credit ) < 1

- (abs_count) = Sum

)

As you see I am a complete newbie with calcualations. Can you point me in the right direction? Thank you.

Try:

Case ( AbsCount ; Let ( deduct = Credit * 18 ; AbsCount - deduct ) )

I wrapped with case so that it would not evaluate unless there was a value.  If your business rules require a different result If one or both fields are empty, let me know.   :-)



Or without the Let() since it really isn't needed:

Case ( AbsCount ; AbsCount - Credit * 18 )

I should explain if you are very new to calculations ... deduct is not a field - it is a declared variable we are using only within this calculation. you might want to use my second calc since it is clearer and more efficient.

AbsCount and Credit are fields.

You are fantastic. It worked perfectly. Thank you.