R
Reetu
Hi All,
I need to set MinimumHours field based on OfficeName field and JobTitle
field.
I need to apply the following formula:
if (OfficeName = "A" or OfficeName ="B") And (JobTitle = "C" or JobTitle =
"D")
{
MinimumHours = 40;
}
I did apply the above rule in the following way but it does not work
correctly.
if OfficeName = "A" or
OfficeName = "B" And
JobTitle = "C" or
JobTitle = "D" then MinimumHours=40
It works if oficeName =B and JobTitle =C. But if OfficeName = A it does not
work. I know there should be some way to group office condition in one
bracket and JobTitle in other bracket but I didn't see a way to do that.
Any idea how to do this?
Regards,
-Reetu
I need to set MinimumHours field based on OfficeName field and JobTitle
field.
I need to apply the following formula:
if (OfficeName = "A" or OfficeName ="B") And (JobTitle = "C" or JobTitle =
"D")
{
MinimumHours = 40;
}
I did apply the above rule in the following way but it does not work
correctly.
if OfficeName = "A" or
OfficeName = "B" And
JobTitle = "C" or
JobTitle = "D" then MinimumHours=40
It works if oficeName =B and JobTitle =C. But if OfficeName = A it does not
work. I know there should be some way to group office condition in one
bracket and JobTitle in other bracket but I didn't see a way to do that.
Any idea how to do this?
Regards,
-Reetu