Aggregation Not Displaying [message #1809209] |
Thu, 11 July 2019 15:09 |
Keith Stramler Messages: 12 Registered: November 2015 |
Junior Member |
|
|
I created a table in Neon with detail which displays properly. However, whenever the report is viewed, the amounts from the query are shown in the detail correctly. However, when I do an aggregation to sum those amounts, nothing displays. I have tried putting an If statement in to make nulls a zero. Whenever I use the detail column name, it has to have the .getnativevalue() on the end of it. I thought maybe this was the issue, so I renamed the detail column name to avoid this, but it still does not work. This should be a simple, straight forward calculation, however, nothing I have tried gets the aggregation to display.
I have attached my report as an example. I can get a total on the group for Fund Source, however, as you can see in the Project Totals, it shows the detail amounts, but 0 as the aggregated sum.
I would appreciate any thoughts or suggestions to try as I am out of ideas on how get this to work properly.
-
Attachment: Capture.PNG
(Size: 34.78KB, Downloaded 88 times)
|
|
|
|
Powered by
FUDForum. Page generated in 0.07928 seconds