Set Qualification to Measure In the Formula window type in the below formula =If [Budgeted Fte] = [Actual Fte] Then "Filled" Else If [Budgeted Fte] > [Actual Fte] Then "Under" Else If [Budgeted Fte] < [Actual Fte] Then "Over" You can also double click on the items in Available objects, Functions, and Operators windows to add them to the formula statement. Click button to validate the formula has the correct syntax. Validate Click button to create the new variable. OK Drag the variable to the last column of your table. Over/Under Click button to save the changes to your report. Save
Set Qualification to Measure In the Formula window type in the below formula =If [Budgeted Fte] = [Actual Fte] Then "Filled" Else If [Budgeted Fte] > [Actual Fte] Then "Under" Else If [Budgeted Fte] < [Actual Fte] Then "Over" You can also double click on the items in Available objects, Functions, and Operators windows to add them to the formula statement. Click Validate button to validate the formula has the correct syntax. Click OK button to create the new variable. Drag the Over/Under variable to the last column of your table. Click Save button to save the changes to your report.