This content has been marked as final.
Show 4 replies
-
1. Re: Scalar arithmetic
Deepak RaiOct 23, 2017 2:02 PM (in response to robert b)
ATTR([Shipment Cnt])*ATTR(([Cost Ship])-[avg_cost])
-
2. Re: Scalar arithmetic
robert b Oct 23, 2017 2:25 PM (in response to Deepak Rai)This doesn't seem to work. The description for ATTR suggests that this will (as a loose, not precise description) compact of ship cnt and cost into a single value (as though it were acting as a functional), to make the entire equation scalar. I want to go the other way--to keep shipment cnt and cost as vectors and subtract a constant value from all rows of cost.
-
3. Re: Scalar arithmetic
Peter Fakan Oct 23, 2017 2:35 PM (in response to robert b)Post an example Robert.
While I can imagine what you are trying to do, an example will vastly assist.
Peter
-
4. Re: Scalar arithmetic
robert b Oct 23, 2017 2:59 PM (in response to Peter Fakan)In create calculate field,
[Shipment Cnt]*([Cost Ship]-[avg_cost])
where shipment Cnt and cost Ship are columns of my data, and
avg_cost=sum(cost ship)/sum(ship cnt) is a previous calculation