Comments
-
Yes, so that would be ideal if my data was set up that way.. I understand what you are saying. I have actual and budget in the data so this works perfectly, but unfortunately Variance is a beast mode calculation. Doing it this way is perfect for Actual and Budget, but then I cannot have a variance number.
-
THANK YOU BOTH! I got it to work with the Trim and Like statements.
-
Hey Mark, For the prescribing facility, everything is uppercase
-
when i add the double quotes it resolves the error message with the formula, but it is not mapping correctly on the backend to the county I am trying to map it to.. Its comes up as my else '0'
-
yes thank you Mark. No idea why it works but it works so thank you!
-
Thank you Stuck. i like the idea of adding Case statement within a Case statement. Going to play with this logic. appreciate the reply