Hi everyone

[Vugar]

I try to create Salary DB and have one problem.

please see below:

FullName D/M BaseSalary BaseDay WorkDays Salary
XX D 500,00 20 22
YY M 500,00 1 15

I want writh formula:

1. If ("D/M" ="D") then ("Salary"="BaseSalary"/"BaseDay" * "WorkDays" )

2. If ("D/M" ="M") then ("Salary"="BaseSalary")

thanks in advance

 

[arnelgp]

you can use IIf() function or switch():

Salary: IIF([D/M] = "M', [BaseSalary], IIF([D/M]="D", [BaseSalary]/[BaseDay]*[WorkDays], 0))

 

[Vugar]

thank you, but there sum mistake in operator.

 

[Vugar]

Could you please check it:

IIF([SM/SS/S] ="S",[SumOfBaseSalary], IIF( [SM/SS/S] = "D", [SumOfBaseSalary] / [SumOfBaseWorkDays] * [SumOfWorkingDays] ,0)

 

[Vugar]

Thank you very very much I find