Jump to content
Sign in to follow this  
Moomphie

IsEmpty field display contents of not Empty field

Recommended Posts

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

Share this post


Link to post
Share on other sites

Calculation for field R:

Case(

not IsEmpty ( D ) ; D ;

not IsEmpty ( W ) ; W ;

not IsEmpty ( M ) ; M ;

""

)

or simply:

D & W & M

Share this post


Link to post
Share on other sites

Dear Daniele

Thank you so much for your assistance both calculations work a treat.

Kind Regards

Moomphie

Share this post


Link to post
Share on other sites

The two calculations will return different answers for the same data.

If you have data in all three fields, then the [color:blue]Case Statement will return the data in field D as expected. However, the Concatenated [color:blue]calculation, i.e. using the [color:blue]"&" Operator, will return all data in all fields.

As an example, if the field cantained the following:

D = 1

W = 2

M = 3

Case Statement will return = 1

& operator will return 123

HTH

Lee

Share this post


Link to post
Share on other sites

Hi Lee

have you read carefully what Moomphie said ?

"(If D displays a result W and M does not), (if W displays a result D and M does not) and so on"

Share this post


Link to post
Share on other sites

Yes I did. AND, I also noted that we are dealing with a Novice, who may, or may not have understood the differences.

Lee

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.