Timeline for System.QueryException in aggregateResults
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 8:11 | history | edited | CommunityBot |
Commonmark migration
|
|
| Dec 29, 2016 at 17:08 | comment | added | shilpa | Thanks Adrian! I avoided using FORMAT() and achieved what i needed by defining the fields in currency type instead of number fields. I am surprised salesforce failed to support what it has listed here developer.salesforce.com/releases/release/Spring_%252716/…. Thanks again for all your responses. | |
| Dec 28, 2016 at 21:31 | history | edited | Adrian Larson♦ | CC BY-SA 3.0 |
added 826 characters in body
|
| Dec 28, 2016 at 21:15 | comment | added | shilpa | I have access to the field. This query runs fine in apex as well when i replace FORMAT(SUM(Opportunity__r.Amount)) with just SUM(Opportunity__r.amount). I guess it has something to do with the currency formatting? | |
| Dec 28, 2016 at 21:11 | history | answered | Adrian Larson♦ | CC BY-SA 3.0 |