Forum Discussion
SHOOKANSON
Advocate I
Advocate ICircular 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
Interkoubess
Solution Sage
Solution SageHi 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
I knew I was missing something simple! Thanks!
