Astroraf
09-25-2025Data Pipeline
CASE WHEN logic in Formulas
Hi DRay ,
I am trying to use the CASE WHEN logic in the formulas but does not seem to work. My logic:
SUM(IF([Total DEFINITIVE_EST_NUM_OF_ER_VISITS]>0, [Total DEFINITIVE_EST_NUM_OF_ER_VISITS], 0))
but this does not give a value of 0 when I am looking in a tooltip map, it stills shows N/A in the tooltip.
I tried a CASE WHEN Statement:
CASE (
WHEN
[Total DEFINITIVE_EST_NUM_OF_ER_VISITS]> 0
THEN [Total DEFINITIVE_EST_NUM_OF_ER_VISITS]
ELSE 0
END)
But I get unexpected token, and from the documentation I am doing everything correctly.
The goal is for the tooltip information for Hospitals with ER visits that have 0 visits to show up as 0 rather than N/A in the tooltip information.