Hi, I am working on a workflow where I need to error out the message when the [Sum Original amount] is not equal to zero or when its empty field. The 0 amount error I have already done but not sure how to do it is a blank field as shown in attached file.
Any help on this.
Note: I don't want to put the Count tool and then error it out..
Thanks in Advance :)
Hi @Tid14 , you can use the Test tool for this. Select the test type 'Record Count Matches Specific Value' and choose the value 1. As you are summarising to one group, you should always have one record. This configuration will throw an error if there are no records.
Hope this helps!