Circular Reference

[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!

[Olivier]

Hi there,

I think you need another dimension reference to do that :

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

FEEDERS;

['Source','Hours']=>['Destination','Dollars'];
['Source','Dollars']=>['Destination','Hours'];


Any other suggestions from the gurus ?

Olivier

[jim wood]

Have you tried using continue instead of stet?