To all who can help
Being a complete novice I would like to have the following answered.
I have three calculated fields. Daily calculated rate (let’s call this D), Weekly calculated rate (let’s call this W) and Monthly calculated rate (let’s call this M). In addition another field within which I would like to display a final result (let’s call this R).
I have managed thus fare to get D, W and M to display their required result leaving the other two empty. I’ll explain (If D displays a result W and M does not), (if W displays a result D and M does not) and so on. This being the case I would like the following to happen.
If D is not empty display D in field R
IF D is empty display W in field R
If W is empty display M in field R
My question is how would one accomplish this task?
Thank in advance to all who reply.
Moomphie
