This content has been marked as final.
Show 4 replies

1. Re: Scalar arithmetic
Deepak Rai Oct 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 wayto 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