
Contributor III
2017-01-27
06:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Sum less than equal 0 values to show on textbox
Hi All,
I;m unable to sum the negative values.
My scenario like this.
Delivery Hours | Shipment Count |
---|---|
-5 | 100 |
-4 | 150 |
-2 | 200 |
0 | 500 |
1 | 300 |
2 | 100 |
Now i want Sum the less than or equal '0' values in text object.
Please help me.
Thanks,
ASHOK
1,471 Views
1 Solution
Accepted Solutions

MVP
2017-01-27
06:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Sum({<DeliveryHours ={"<=0"}>}ShipmentCount)
2 Replies

MVP
2017-01-27
06:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Sum({<DeliveryHours ={"<=0"}>}ShipmentCount)

Contributor III
2017-01-27
06:39 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you.
1,350 Views
