|Aggregation Not Displaying [message #1809209]
||Thu, 11 July 2019 15:09
| Keith Stramler
Registered: November 2015
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.
(Size: 34.78KB, Downloaded 28 times)
Powered by FUDForum
. Page generated in 0.03127 seconds