Forum Discussion
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...
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
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
I knew I was missing something simple! Thanks!