
Creator III
2021-09-30
09:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis with Greater than Amount
Hi,
Based on what I found online I believe the following formula should work but it doesn't. Any Suggestions?
Sum({$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {">= 5000"}>} OSAmt)
Thanks!
4,566 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
11 Replies


Partner Ambassador/MVP
2021-10-01
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you test this by manually making selections that match the set?
-Rob
614 Views

MVP
2021-10-01
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI
Try like below
Sum({$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, urPrimaryKeyField= {"=Sum(OSAmt)>= 5000"}>} OSAmt)
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.

- « Previous Replies
-
- 1
- 2
- Next Replies »