Skip to main content
Solved

Aggregation Sum on checkbox in Universal GUI

  • May 8, 2025
  • 3 replies
  • 78 views

Forum|alt.badge.img+5

In Windows it is possible to do a sum on a “checkbox”, where the domain is INT

 

 

 

In the Universal GUI, this doesn't work
 

Would be very nice if this option will also work in Universal GUI

….ef_evnt_event_staff_planning?$apply=aggregate(count_using_dinner%20with%20sum%20as%20count_using_dinner_sum)

Results in 500 error :-(.

Is there a way to make that work?

Best answer by Anne Buit

If this is the root cause, please create an Indicium ticket for this.

This should be supported out-of-the-box without having the convert the datatype yourself💪

This topic has been closed for replies.

3 replies

@avandervelden Is the screen you are showing by any chance a “view”? It could be that the definition is seeing it as perhaps a BIT (or another data type) instead of a TINYINT.

If so, use a CAST() or CONVERT() to make it match.

Example to use for specific column in your Control Procedure template of your view:

CAST(0 AS TINYINT)

I also get a 500 error when I CAST() it as a BIT.


Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • Answer
  • May 9, 2025

If this is the root cause, please create an Indicium ticket for this.

This should be supported out-of-the-box without having the convert the datatype yourself💪


Forum|alt.badge.img+3

Hi,

This issue should be fixed in the next version of Indicium (2025.1.15.0). I expect this version to become available on 06/30/2025

Regards,

Dick van den Brink