If Condition in for each query in invoke code

Help Activities
1

If Condition in for each query in invoke code

Use Case Description

Hi Team,
Just needed a help in one of the for each query that i have used in invoke code activity. I am Attaching my code below:
downloadedfile_DT.AsEnumerable().ToList().ForEach(Sub(row) row(“Difference”)=CDbl(row(“Rate/Unit”).ToString)-CDbl(row(“Price from Price Master”).ToString))
This code is working absolutely correct. But in addition to this code, i want to check for those values in “Rate/Unit” column and “Price from Price Master” column that are non null only. So, how can i add if condition in this query please help me with it.
Thanks in Advance.

AS-IS WORKFLOW, TO-BE WORKFLOW

-

Other information about the use case

Industry categories for this use case: Information Technology and Services

Skill level required: Intermediate

UiPath Products that were used: UiPath Studio

Other applications that were used: -

Other resources: -

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency

2

Would it be acceptable to consider the NULL values as a 0 for the calculation? If so, maybe you could try something like this:

image
image1147×97 26.1 KB

I didn’t try it out, but it’s just to give you an idea.

3

Hi,

This seems duplicated post. Doesn’t the following replies solve your matter?

Regards,

4

Sorry @Yoichi , I actually by mistake posted it as a use case. Sorry for the inconvenience.