Forum Discussion

SHOOKANSON's avatar
SHOOKANSON
Advocate I
8 years ago
Solved

Circular Dependency - Simple Fix?

Hi all,   I am having an issue which I hope there is a simple fix for. I am trying to create two calculated columns (I cannot use measures because I need it to calculate row by row) - a sell column...
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi SHOOKANSON,

     

    If you want to compute row by rows, then you can use SUMX.

     

    SO for example in your case, you can have 

    SELL = Sumx( Table, SELL*QTY)

    COST=SUMX(Table, COST*QTY)

     

    Please give a sample if you keep having trouble with the formulas,

     

    Ninter

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi SHOOKANSON,

 

If you want to compute row by rows, then you can use SUMX.

 

SO for example in your case, you can have 

SELL = Sumx( Table, SELL*QTY)

COST=SUMX(Table, COST*QTY)

 

Please give a sample if you keep having trouble with the formulas,

 

Ninter

  • SHOOKANSON's avatar
    SHOOKANSON
    Advocate I
    8 years ago

    I knew I was missing something simple! Thanks!