using the visual cues

[zturaiki]

I have this Table

Doctor Code	Prescriptions 2013 June	Prescriptions 2013 July
A	936	936
B	849	740
C	676	612
D	576	575
E	567	290
F	548	484

Total No. of Prescription for June and July for each doctor

i need to make a comparasion between these tow month,.,.. if the total No. ot prescription of Dr.A in June is Geater than Total No. of Prescription in July

this value in the font for the value will be green ... and if not,,, it will be red ...

as u can see  in the picture :

[#2 · Accepted solution]

in text colour--

write if(precription2013july<precription2013june,red(),green())

[ariel_klien]

Hi

Try to put this in the expression > text color

if(sum({<DoctorCode=>} Prescriptions2013June)=sum({<DoctorCode=>}Prescriptions2013July),Green(),Red())