HI,

Am trying to define a field so that i can do some manipulations. For example , i need to show the prescription number , hence i need to do some manipulations liek below :

DEFINE FILE XXX
RX/P20 = IF RX1 EQ LAST RX1 THEN ' ' ELSE RX#;
END

The format of the field is :

RX# E04 P20

Hence when i use P20 as the format i get the below error:

(FOC282) RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD: RX

Even if i use D20 , i get the same error.

Can somebody help please ?

Thanks!
Janani

This message has been edited. Last edited by: Kerry,

You can not put space in a numeric field

  
DEFINE FILE XXX
RX/P20 = IF RX1 EQ LAST RX1 THEN 0 ELSE RX#;
END

quote:

DEFINE FILE XXX
RX/P20 = IF RX1 EQ LAST RX1 THEN ' ' ELSE RX#;
END

If you want use missing value:

DEFINE FILE XXX
RX/P20 MISSING ON = IF RX1 EQ LAST RX1 THEN MISSING ELSE RX#;
END

Alternativly define RX as RX=P20S

That will suppress the zero for display purposes but will allow counts to work correctly if you are using them.

Thanks for all your help!!!

Janani