Has anybody been able to route a form based on a value in a collection table.
I have a scenario where any one of my collections are > than 10000.00 the task needs to go for approval else the process can end.
I have set up my conditions however the process just keeps on failing.
The field on the form is currency and my routing rule is (/dataset/Claims/Claim_Amount)>10000.00
One the other path I have tried leaving the path as default with no ruling (but with this the process ends but does not route correctly)
I have tried setting a rules as (/dataset/Claims/Claim_Amount)<10000.00 but than the process terminates.