Maximum Value based on Condition

[RohitGaur]

Hi,

I have one table name Mst_User and it has two columns.

Column1 =  Category ( This is a List column and have two list values "Contractor", "Company Employee"

Column2 = EmpCode (Number)

Condition:

1. When i select Contractor, it should pick the maximum value of EMP Code + 1001. This value should be appearing in EMP code.

2. When i select Company Employee, it should allow me to enter value.

I have applied IF condition, Max() and IFS but getting following error message: 

Valid_IF:

IFS(
[_THISROW].[Category]="Contractor",
(MAX(List(Select(Mst_User[EmpCode],[Category]="Contractor"))))+1001
)

"The expression is valid but its result type 'Number' is not one of the expected type: Yes/No"

Appreciate your help on my query.

Thanks,

Rohit Gaur