I used the "full accumulation" option and it worked perfectly.
Now I want to use the resulting accumulated field (Sales To Date at cost) and add it to (Remaining Inventory at cost) to get Total Inventory at cost.
The second field should not be accumulative (Total Inventory at cost), but the first should (Sales To Date at cost).
I tried to just use the first field name (Sales To Date) in a formula for the second field (Total Inventory) without setting "full accumulation" checkbox, but it looks like it recalculates the field without accumulation.
Can I force it to use the already calculated field value (where accumulation is on)?