Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have to create a calculated Column "A" for which the formula would be something like this

=IF(SomeCondition = True,[A] + [B],[A])

however on trying this i am getting following error

"The formula contains a circular reference (the calculated column refers to itself). You must remove or change the circular reference."

Is there any workaround for this?

share|improve this question
    
What are you trying to do? A=A+B makes no sense in the context of a ROW of data. –  Ryan May 23 '13 at 13:15
    
Thanks for ur response....well i m trying to add to or retain the previous value of the calculated column based on some condition....nd also i did'nt understand "A=A+B makes no sense in the context of a ROW of data"...can u elaborate a bit? –  Divyendu May 24 '13 at 6:22
    
Play with this on Excel as it will be clearer. You can't do in cell A1 the formula =A1+B1 - it doesn't make sense, there is no way to 'retain the previous value'. Same as in normal algebra - this is not a procedural programming language. So again - explain the business requirement behind this and there may be another way. –  Ryan May 24 '13 at 17:47
add comment

2 Answers 2

What exactly are you trying to do?

Your current calculation checks if TRUE == TRUE and if so returns [A] + [B], otherwise [A] (but that can never happen since TRUE is always TRUE)

This Office documentation is really helpful for finding example calculations to modify. But if you clarify exactly what output you would like (prefferably with an example) we can help you easier.

share|improve this answer
    
Thanks for ur resoonse...Well what i m trying to do is IF(SomeCondition == True) Set A = A + B Else Don't change A –  Divyendu May 24 '13 at 6:02
add comment

Calculated column doesn't have a value outside the formula, so using it as a part of assigning itself a value makes no sense.

Please explain what exactly you are trying to achieve

share|improve this answer
    
Thanks for ur response....well i m trying to add to or retain the previous value of the calculated column based on some condition –  Divyendu May 24 '13 at 6:04
    
I don't think you can and I don't think calculated column is meant to be used like this. –  Andrey May 29 '13 at 16:56
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.