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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

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