General

Re: condition

Jimmy — Wed, 12 Dec 2012 16:30:06 GMT

Shouldn't leave required be 7.5 - field10?

Re: condition

stormcat73 — Wed, 12 Dec 2012 15:08:25 GMT

thank you for the reply Jimmy

i am having trouble with this condition

i set field10<7.5 and not black and create a formula filed10-7.5

the issue is that -7.5 keep chowing in the leave required field so i tried translate((. - 7.5) * -1, "7.5", "0")

now when it calculate the amount is not right due due to the translate.

do you have a solution

thanks,

Zee

Re: condition

Jimmy — Tue, 11 Dec 2012 12:17:27 GMT

Your condition looks good, but be aware that a rule only runs when the field it's applied to has its value changed. Is that what you're expecting here?

Also please make sure that the field's data type is set to numeric. If it's not, please change it, then delete and re-add the condition.

condition

stormcat73 — Tue, 11 Dec 2012 11:52:44 GMT

HI,

I have a field worked hours and have two other field that the calculation depend on leave required and overtime.

what i am trying to do is if hours worked is greater than 7.5 then it calculate for over time .

and the other way for leave time if worked hours is less than 7.5 then calculate leave required.

I tried this condition field10 > 7.5 then run the action but it does not work can anyone please help.

Thanks