OK, I’m able to reproduce it, but I’m not sure I fully understand what’s happening…but I kind of do…but I’m not sure I want to classify it as a bug yet.
Can you show me how your SearchedValues column is configured? At some point that number is getting converted to text with the commas intact, and that throws the math column for a loop because it’s not expecting anything other than raw numbers, and by default it treats commas as decimals. If the IF column was returning a raw number without any dollar sign or commas, then everything would work. I feel like you have an extra template column or something else that the SearchedValues column is returning, so it’s only treating the numbers as text instead of actual numbers.