Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
HI
Try like below
Sum({$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, urPrimaryKeyField= {"=Sum(OSAmt)>= 5000"}>} OSAmt)
@greend21 Try with single quotes.
Sum({$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {'>= 5000'}>} OSAmt)
OR
Sum({$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {'=SUM(OSAmt)>= 5000'}>} OSAmt)
Unfortunately that doesn't work either.
What are you trying to do, what is "not working"
OSAmt = {">= 5000"} is going to limit at the row level for each OSAmt. Are there records in the data model that are >5000 or is it the sum of OSAmt you need greating then 5000.
Your expression does look fine. And i assume there are records >=5000 AND SuretyOver90Ind=1 AND RecvOpenStatus= 'Open'?
1) Are you sure OSAmt a numeric type field? I suppose it is if your sum expression works without the >=5000 filter.
2) Are you seeing any syntax issues in the editor?
Sum({$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {">= 5000"}>} OSAmt)
Ok, unfortunately I don't know of any other reason it's not working. Can you share a sample data set with the issue?