This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need some formula suggestions or help. Below are two formulas in which I am trying to assign a 1 if below a certain threshold. I am trying to say if the metric is below a certain level or if it is blank then assign it a 1, else 0. I have tried the following below but it is not picking up on the null or blank portion. I will admit that I have a basic level of craftsmanship when it comes to writing formulas, so I would appreciate your help with the following below:
If [Net_Patient_Rev_3Y_Growth]<0 or "" then 1 else 0 endif
If [Ebitda_3Y_Growth]<=-.10 or "" then 1 else 0 endif