Negative entities not joining

Question

Hey Guys,

When I perform a join on the metrics of Key and Payment Amount, I can see that the Keys and amounts match. However, those records are not showing up in the Join. The only reason I could see for that is the fact that these metrics are negative. I have attached screenshots in order to showcase the situation. Is there something else I am missing and if not how do i bypass this?

Thanks,

Remaining Invoice Record.PNG

Remaining CPT records.PNG

Join that worked.PNG

fmvizcaino · Accepted Answer

Hi @apoorvsingh ,

I've tested here the same negative value and the join worked as expected. One thing that could be happening is a rouding issue with your doubles.

I suggest you to round your values with the function round or to change the format to fixed decimal or even insert the numeric value in your key as well.

Let me know if this makes sense to you.

Best,

Fernando Vizcaino