Share
ReportHi there, as i understand it, i should be able to sum a calculated field via a rollup field as long as it does not reference another calculated field.
Within my system i have a custom table a bit like "order" which we integrate from our ERP. I have a decimal field that = quantity, i multiply that by the unit price (currency) from the related product on the order set a "total order price". (My calculated field). Both source fields for the calculation are standard dynamics fields (quantity on order and unit price on product). On the Parent entity i then want a rollup field to add all the "total order prices" (my calculated field) together. Simple right?
Why cannot i not select this field when i try to, on the definition of the rollup field? It does not appear as an option, I am nowhere near the 100 rollup limit for the system. I have tried storing the unit price value on the "order" record itself because i thought there may be an issue performing the rollup via a calculation field that references another related entity i.e. the "product" (this did not help). I also tried deleting and recreating the rollup field, did not help. Is there an unwritten rule somewhere i don't know about?
Daniel
*This post is locked for comments
All responses (
Answers (
30,188
