Circular reference

[jonathan.d]

Would to repost this issue as I have the same.

This one was never resolved.

it was by kielmc


Hello everyone!

I guess I'm dreaming, but I could swear that I've been able to do this before, using STET would to avoid a circular reference...

I'd like to be able to enter either hours or dollars and and have the other calculate...I've simplified the rules as an example below. Is there a way to do this without creating a third measure?

['Dollars']=IF(['Hours']=0,STET, 1);

['Hours']=IF(['Dollars']=0,STET, 1);

Thanks!

[John Hobson]

I can't see this working without a third element (some sort of flag)

Presumably the calculated result of Dollar or Hours could = 0, so I can still see potential circularity in you current method

If you use this kind of logic:

FLAG = 1

Sales Budget = if flag = 1, Stet, Sales * Increase % / 100

increase % = if flag = 1 , Sales Budget - Sales / Sales * 100, Stet

You achieve what you want don't you? (OK you have to store a flag too)

HTH