You have to invoke another one detail column disc_val and edit its property palette make formula field as quantity * discount.
2 "per unit" 20 10 2 20 10 2 20
Then create a text item with the name of tot_disc_val and change its property as follows:
calculation mode: summary
summary function: sum
summarized block: <your detail block>
summarized item: disc_val
1 person found this helpful
... and it does not need to be a visible field.
Make sure you set precompute summaries or query all records so it works Ok during a query.
Can you describe how it doesn't work or give us the error this generates (if any)? "Doesn't work" is not very helpful.
it seems "sum" is not acceptable in the formula statement
i tried Priyasagi & KevinD.Clarke solutions and i works
Thanks all for ur help
Then, choose the best answer as correct and close the thread.