I have created two identical fields that do the same excel functions to render an answer. I then created a “dummy” math field to reference that excel formula answer so that I can format the numbers to the preferred format i.e. $x.xx
I then rollup those “child” object fields to a “parent” and in one column I can have it Sum the field, and in the second column referencing the “twin” it does not allow for Sum???
One of the fields references a data field that is used in Scenario 1
The other field references a data field that is used in Scenario 2
Both calculations are identical up to the result fields -
resultField1 = 123.456789
dummyFieldUsedInRollup1 = $123.46
On the parent object I can rollup all of the dummyFieldUsedInRollup1 fields from the various child objects and I can Sum them.
On the same parent object I cannot rollup dummyFieldUsedInRollup2 and use Sum?
I have followed the fields all the way back to the base of the calculations and they are identical - obviously other then the one field for scenario1 and scenario2 but both of those are simply number fields so that should not matter.
I saw this post: Rollup math functions are not working with if-else column
Which I am doing via the “Dummy” fields. Just an FYI as I have searched the forum and have come up empty handed so far