C1GridView grouping sum negative

Posted by: jaeichenauer on 10 September 2017, 11:50 am EST

  • Posted 10 September 2017, 11:50 am EST

    Is there a way to have a grouped row be subtracted from the group aggregate, and still display a positive value?
  • Replied 10 September 2017, 11:50 am EST

    Hello,

    Can you please elaborate more on this issue, as in what is your exact requirement? You want to subtract which value from group aggregate?
    It will be helpful if you can post some code or screenshot for explaining the issue.

    Regards
    Nidhi
  • Replied 10 September 2017, 11:50 am EST

    Let me try to explain first without code or a screenshot, but rather a simple example.
    Suppose I want to group up 3 rows of values into a total row. All three rows would display positive values for all cells. However, row 3 would be subtracted from the total instead of added. It would look like this if there was only one cell displayed:

    Total Row: 10
    Row 1: 5
    Row 2: 6
    Row 3: 1

    So far, I have not been able to figure out how to do this without having a negative value showing for Row 3, which I don't want to do, such as below:

    Total Row: 10
    Row 1: 5
    Row 2: 6
    Row 3: -1

    Also, I need to do this dynamically in vb code, not using the Design page.

    Thanks!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels