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)?
You should create a formula for the "Sales To Date at cost" field without the full accumulation option checked.
Then add the "Sales To Date at cost" and "Remaining Inventory at cost" expressions to get the " Total Inventory at cost" expression.
See the attached file.
test.qvw 153.0 K