I could need some help with UiPath. Here is my case:
So far, my RDA downloads several reports for different countries from a business intelligence tool. The report lists all customer numbers for the selected country and the respective order intake figures. However, the number of rows is limited to about 500 in that BI tool. Therefore, I have to check if each report is complete already or if I have to download additional reports (=> if the original report is not complete I can just download reports for each month of a specific country and merge the figures via a pivot table).
In order to find out if a report is complete, I have to compare the total amount of all new orders (cell C4) with the sum of the orders that are really included in the report. To do so, my RDA writes “=C4-SUM(C5:C519)” into cell C520 => if the value of the formula is 0, both figures match and the report is complete. What I would like to implement now in UiPath is a mechanism that checks automatically if the value of C520 is 0 and if that is TRUE, the file should be saved. If the condition is FALSE, the file should be deleted and my RDA should download the figures for that specific country again, but that time for each month individually.
Here is my question: How can I let my RDA check if the value of C520 is 0 and then decide accordingly?
My plan was to use “Read”, then define the output of the “Read” activity as an integer variable (or argument?) and afterwards integrate that variable into an “If” activity. However, I always receive an error description that is related to the “Read” part. Is “Read” not applicable for this case or am I just using it the wrong way?