Issue using Sum Values Function

Ask a question
1

Hi guys,

I’m noticing what I think is a bug in the tool when I try to use the Sum Values function.

In my flow I have a list of orders and I am just looking to sum the Gross Sales column using the Sum Values function. In the step preceding the Sum Values function I can see the below value of 1,147.20 when I search ENFA-1280.
image

But after using the Sum Values function, I’m seeing a 0 under Gross Sales when I search ENFA-1280:

image
image952×289 18.8 KB

Can anyone help me troubleshoot this?

Thanks,

Aadit

1 Like
2

Hey Aadit,

Appreciate you pointing this out. I’ll pass a note along to the team to look this over, but in the interim, you could potentially use the Number Formatter step to remove commas. That way the Sum Values step should treat the column as a numeral and not text. Hope that helps for now!

3

Hi @jp, thanks for the pointer. I did try that but no luck, for some reason in my flow that column has values showing up as 0 randomly, i.e. not affecting the entire column, just some rows in it. Any suggestions on how to troubleshoot?

Thanks,

Aadit

4

@jp - ok think I figured out what the issue was. There was a Number Formatter already in my flow in a preceding step that was adding commas to numbers. For some reason, this earlier step was causing numbers to appear as 0 in Sum Values function, as shown in my screenshots.

Once i removed the option to add commas in the preceding Number Formatter step , the Sum Values function captures the values fine and is working now.

1 Like
5

Glad to hear Aadit! We will look to make working with numbers of all types easier going forward.

1 Like