The following formula is not enforcing the minimum wage rule - either Jobz__r.State_Minimum_Wage__c or 10 - the greater of the 2 is the minimum... unless CA - then minimum is $25. Formula: IF( OR( ISBLANK( Est_Rev_Value__c ), Hours_for_Formulas__c <= 0 ), 0, ( Est_Rev_Value__c * (1 - Target_Margin__c) - VMS_Fee_Wkly_Amt__c - MIN( Jobz__r.GSA_Weekly_Housing__c, MAX( 0, ( Est_Rev_Value__c * (1 - Target_Margin__c) ) - Total_Fixed_Expenses__c - ( IF( Facility_State__c = "CA", MAX(25.00, BLANKVALUE(Jobz__r.State_Minimum_Wage__c, 25.00)), BLANKVALUE(Jobz__r.State_Minimum_Wage__c, 10.00) ) * ( ( MIN(Hours_for_Formulas__c, 40) + MAX(Hours_for_Formulas__c - 40, 0) * 1.5 ) * 1.08 + ( Unbillable_Hours__c / MAX( Contract_Length__c , 1) ) ) ) ) ) - Total_Fixed_Expenses__c ) / ( ( MIN(Hours_for_Formulas__c, 40) + MAX(Hours_for_Formulas__c - 40, 0) * 1.5 ) * 1.08 + ( Unbillable_Hours__c / MAX( Contract_Length__c , 1) ) ) )
Can you create a List View or Report that displays all of the Fields that are in your Formula AND the Formula Field side-by-side showing multiple combinations of input values and results and post a screenshot?
It's a LOT easier to troubleshoot when we can see the Input Values going into the Formula and the Output/Results together.
