Filter formatnumber confusing

How To
1

Image 1

Screenshot_1
Screenshot_1960×683 53 KB

Image 2

Screenshot_2
Screenshot_2913×684 55.2 KB

Image 1 filter works perfectly.

Image 2 filter doesn’t work - means it doesn’t let the data pass even thougth the numbers are equal

example: 1 = 1

What’s the logic behind it?

2

Detailed explanation.

Image 1

million verifier id is 450 and it’s in a text format

  1. file: file_id is in number format

We’re using numeric operators - why it’s working in text also?

Image 2

I convert the text into number and it didn’t work even though

million verifier was 450 (converted)

  1. file: file_id was 450
3

Hello @itsmeayyub,

I’ll try to help here.

formatNumber() function needs at least two parameters, the number you want to format, and the number of decimal places. The other parameters are optional. The way you’re calling it only has one parameter, the number.

If million verifier is text, then formatNumber won’t work on it. formatNumber() only works on numbers. Change it to a number first by using the parseNumber() function. You may only need to use parseNumber() if all you’re doing is comparing two numbers.

If File ID is in number format then you can convert million verifier to a number first then use the Numeric Compare options to compare to File ID.

4 Likes
4

Thank you so much @Donald_Mitchell I forgot about the parsenumber.

3 Likes