Skip to Content
0

Show result in Colors

Dec 08, 2016 at 10:52 PM

70

avatar image

HI I have a formula

If ({Diagnosis_Codes.Diagnosis_Code} IN ['V20.2', 'Z00.129'])
Then
'Well Visit'
else
'No Well Visit'

And we display it as max. The users want 'Well visit' should be in green whilst no well visit should be Red. Is the only way that I make a variable with this colors?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Abhilash Kumar
Dec 12, 2016 at 02:36 PM
1

Hi Paul,

Right-click the formula field on the section > Format Field > Font tab > Click the formula button beside 'Color' and paste the code in here.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Brian Dong Dec 08, 2016 at 11:00 PM
0

Hi Paul,

You'll have to do this in the format editor. Right-click on the formula and go to Format Field. In the Font tab tab, click the formula button beside Color. In there you can create a formula like:

If {@myFormula} = "Well Visit" Then 
    crGreen
Else crRed; 

Good luck,

Brian

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Brian, it doesn't do the green for all of them. And not when the patient has more than one 'Well visit' it only greens the first one the others are red.

0
Abhilash Kumar
Dec 09, 2016 at 08:24 AM
0

Hi Paul,

You can also use:

If currentfieldvalue = "Well Visit" Then 
    crGreen
Else crRed;
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Abhilash - where does this code go? in the formula or a new formula.

0