1

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?

  • 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
1

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.

  • 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
0

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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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