I just returned from Empower where I attended a session that included information on forms calculations. The Laserfiche staff speaker presented an example that used a "hidden multiplier" field which determined a multiplier based on a value using the IF function:
=IF(Holiday_Travel.Yes,"1.25","1.0")
The resulting HiddenMultiplier variable was then used in a calculation of travel expenses, using 1.25 if the Holiday Travel question variable was Yes, 1.0 if not.
I'm trying to apply this same concept to an overtime calculation in a table:
The idea is that if STR (Straight Time) is selected the multiplier should be 1.0, if not the multiplier is 1.5, so my "Hidden Multiplier" field calculation might look like this:
=IF(Group_OT_Details_Post.OT_Type_Post.STR,"1.0","1.5")
However, I can't figure out how to employ this in a table. I've tried both creating the Hidden Multiplier as a separate field outside the table and also as a hidden column in the table, then tried various PRODUCT calculations in the Hours Earned field, such as:
=PRODUCT(INDEX(Group_OT_Details_Post.OT_Hours_Worked_Post,ROW()),HiddenMultiplier
All of the variations I've tried either do nothing or show a calculation error.
Any thoughts? Thank you.