Infinity Symbol in Case Statement

Get Help
1

Hi,

Is there a way of using "Infinity" within a case statement, where I already have an integer as one of my outputs? The statement would be on these lines:
= CASE([Total Current Month] = 0, 0, [Total Previous Month] = 0, Infinity, 1)

TIA

2

I think that's going to be database dependent. Personally, I'd change the query to return text so that you could define the symbol to be used.

3

Hi @AndrewMBaines - when creating the above case statement directly via a query from the database, I am using 'inf'. However, the same syntax is not working within Metabase.

Unfortunately I cannot change the query to text either due to some conditional formatting applied after.

4

What's the database?

5

Snowflake