We have a report that generates results for commission to pay our sales people. Our commission calculation is customized for use. We now need to enhance this report to use Date Closed in a formula on the Results.
The result field labelled Commission Amount needs to use the Date Closed field. What is the field id for Date Closed. When I try "dateclosed", it results in "field not found". I have provided an example of the formula(date) that we want to implement using the Date Closed.
Any help would be greatly appreciated.
NVL(CASE WHEN {custbody_gsl_1099_reps} ='F' and {dateclosed} < '06-01-2023' THEN {custbody23} WHEN {custbody_gsl_1099_reps} ='T' THEN {custbody22} ELSE 0 END,CASE WHEN {custbody_gsl_1099_reps} ='F' THEN {custbody25} WHEN {custbody_gsl_1099_reps} ='T' THEN {custbody26} ELSE 0 END)
Criteria for saved search:
Results tab has the following fields: