Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
09-25-2025

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], ...
dashboards & reporting
HamzaJ's avatar
HamzaJ
Data Integration
09-26-2025

Hey Astroraf​ ,

You do not need ( and ).
CASE  WHEN [Total DEFINITIVE_EST_NUM_OF_ER_VISITS]> 0 THEN [Total DEFINITIVE_EST_NUM_OF_ER_VISITS] ELSE 0 END 
should work

 

Hamza

Astroraf's avatar
Astroraf
Data Pipeline
09-26-2025

HamzaJ​  the formula does work, even though in the hover over in Sisense it says to wrap it in a ( ) from the When statement, but unfortunately this does show the N/A as zero