Discrepency in solutions

[prakashatutd]

 Dataset: Compensation

Analysis Task: Employees at Company A are guaranteed their salaries regardless of meeting their sales goal. If the meet their sales goal, they also earn a bonus, which is an additional percentage of their base salary (shown as a decimal in the data). Given the provided dataset, what is the average total compensation (salary plus bonus if applicable) for employees at Company A?

Issue faced : The values for Average Compensation from  Approach - 1: (Use one formula) differs from  Approach - 2 (uses multiple formula). 

Request: Looking for troubleshooting this discrepancy    

[Raj · Accepted solution]

@prakashatutd 
you need to update the formula in second approach and result will be obtained similar to first

IF [Actual Sales]>=[Sales Goal]
THEN [Salary]+(([Actual Sales] - [Sales Goal])*[Bonus Percent])
ELSE [Salary]
ENDIF

mark done if solved.

[prakashatutd]

Thanks! Very much appreciate it.