Skip the rows according to the conditions

[Gaurav0001]

Hello,
Is there any ways to skip the condition rows while doing SUM, but on count it should not skip the conditional row.

For Example.
Amount have 5 rows and it contains some Hexadecimal numbers.
I wanted to skip the Hexadecimal Numbers while performing the SUM,
But while count the Amount field, Should not skip the Hexadecimal number.

Amount

5

1.6

7

1.72529029846191E 09

4

Output :
SUM : 17.6
Total Number of Rows : 5

Thank You in Advance.

[bgreedy]

For the example you gave I'd suggest doing each process separately then combing the results

• Filter out any Hex numbers and sum-up the total
• Count the total rows of all records
• Combine results with an append

[gawa]

hi @Gaurav0001 

You can create another column by Formula tool, and configure expression so value=0 when condition is met(Hexadecimal).

For that column, apply Summarize tool as usual.

This is an example of the above method. Please rephrase expression so as to fit your case.

[maazumders]

I've attached sample workflow and file for your reference. It get the desired answer. Please let me know your thoughts.