To see the cumulative value of a field even if that field is another formula field
In this case, the client wants to see the cumulative value of the difference of another two numeric fields added in the custom record.
Create a custom record, fields and add the entries
Then Create the saved search
The formula used for getting the cumulative value
sum/* comment */({custrecord_jj_field_1}-{custrecord_jj_field_2}) OVER(PARTITION BY {owner.entityid} ORDER BY {internalid} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
{owner. entityid} should be the same value for all entries. Otherwise the search will not work properly.