You need to sign in to do that
Don't have an account?
360LDEV
Rollup Summary field with odd value in database
Hi all,
I just identified a weird behavior on a Rollup Summary Field. When I remove all the child records it's summarizing, the rollup summary field value should be 0, but instead the field's value is 4e-40 in the database (in the UI, $0 is displayed), which makes no sense ! I've spot another example with another value : 4e-35.
Further details about the concerned field :
- Data type : Roll-Up Summary
- Summary Type : SUM
- Summarized object : Opportunity Product (from Opportunity)
- Field to aggregate : a custom currency field.
Our Active currencies are EUR, GBP and USD, our corporate currency is EUR and the concerned records are in USD.
Anyone has already experienced this? How could I fix that?
Thanks for your help !
I just identified a weird behavior on a Rollup Summary Field. When I remove all the child records it's summarizing, the rollup summary field value should be 0, but instead the field's value is 4e-40 in the database (in the UI, $0 is displayed), which makes no sense ! I've spot another example with another value : 4e-35.
Further details about the concerned field :
- Data type : Roll-Up Summary
- Summary Type : SUM
- Summarized object : Opportunity Product (from Opportunity)
- Field to aggregate : a custom currency field.
Our Active currencies are EUR, GBP and USD, our corporate currency is EUR and the concerned records are in USD.
Anyone has already experienced this? How could I fix that?
Thanks for your help !