Format Number converts variable into string

Why does format number convert a numerical variable into string? This makes it difficult to perform further calculations and new variables need to be created. Numbers after using format number should be in the numerical form and be used for further calculations.

Hi @KayVee
This is the expected behaviour. It becomes a string after adding commas. Ideally, number format should not be used in any intermediate variables that you are using in calculations, it should only be used in the final variable that you actually want to display in the dashboard.