Sum not matching

[Mangalam]

I tried to duplicate a line item multiple times by using generate rows node and then i added a formula node to divide the amount in each line by number of lines. For example if the amount was 1000 and i replicated the line 10 times, then amount in each line is divided by 10 (1000/10). But after appending these 10 lines, the total sum of amount in all 10 lines is not equal to the original amount. How do i rectify this?

[mathieuf]

Hi @Mangalam,

I tried to simulate your case in the workflow below.

Is this what you are looking for?

[Mangalam]

Hi Mathieuf,

I have a similar workflow, but the amount that I have is much higher.

12919648699303804928 - this is one such amount. I tried using your workflow but the sum changes. Could you help me with this?

TIA

[mathieuf]

Are you able to share a sample data so I can try?

Or you workflow?

[Jonathan-Sherman]

Hi @Mangalam,

Could it be that you've stored the value with the incorrect data type? Since your example 12919648699303804928 is such a large number you can't simply use int16 to store the value. I've amended @mathieuf 's workflow to use a double data type instead and it works for your example?

Attached an updated workflow!

Kind regards,

Jonathan

[Mangalam]

Hi,

I have used the same nodes as you did, except the amount value. My data has amounts like that and that's the issue. Is there a way to work with such big numbers?

[Mangalam]

Thanks for the change @jonathan. But I already tried making it double.

But as soon as it changes to double the amount changes as shown below.

So the sum also changes in the end. Is there a workaround for this?

[Jonathan-Sherman]

Hi @Mangalam,

can you attach your version so we can take a look?

Kind regards,

Jonathan

[Mangalam]

Here is my version of workflow.

[mathieuf]

@Mangalam 

Playing with numbers 😄