Jump to content
Sign in to follow this  

Account Name Calc

Recommended Posts

I have a field that I want to use to record the account name of the user who modifies a refund field. The calculation looks like this:

[color:red]Case ( Refund = "Yes"; RefundEnteredBy = Get ( AccountName ) )

By default the refund field is set to 'No'. Therefore, if the user changes that to 'Yes' then I want the RefundEnteredBy field to record who changed it. So far, all this does is return a zero and not the account name. I've tried altering this many different ways with the exact same result. All zeroes.

Any thoughts?


Share this post

Link to post
Share on other sites

You've set up RefundEnteredBy = Get(AccountName) as the result of a Case statement. What you want as the result is Get(AccountName). You've been getting a 0 because that's the 'false' result of the test RefundEnteredBy = Get(AccountName), assuming no users have the AccountName of "Yes".

Change "RefundEnteredBy = Get(AccountName)" to "Get(AccountName)".

Share this post

Link to post
Share on other sites

yeah. like david said

calc should be :(

Case ( Refund = "Yes"; Get ( AccountName ) )


Case ( Refund = "Yes"; RefundEnteredBy = Get ( AccountName ) )

because RefundEnteredBy calc = Case ( Refund = "Yes"; Get ( AccountName ) )


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.

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.