Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Circular reference

LuckyRaju
7 - Meteor

i am attaching the spread sheet which has calculations using Circular reference. I want convert this in to Alteryx workflow. please help me

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@LuckyRaju 
 Before we go to alteyrx. 😁
I tried to modified the "Net Taxable" and nothing changed in the Excel calculation.
Sorry to ask but you sure this circular reference calculation is correct?

 
 

Capture12.PNG

LuckyRaju
7 - Meteor

PLease use the attached file.  I think Circular reference option was not set. 

 

File --> options --> Formulas --> Enable iterative calculation  

 

LuckyRaju
7 - Meteor

Can someone help to create the ALteryx workflow the Circular reference which is used in Excel. 

Labels
Top Solution Authors