Good morning.

I need beleive a compute this field have admit char '- -' and number , i dont know that format put example:

TABLE FILE EXPENSES
SUM
COMPUTE FIELD/D12.2 = IF FIELD EQ '' THEN '--' ELSE FIELD ;
BY NAME
END


NAME FIELD
JON 7.8
JANE 6
FRANCIS --



I dont know that format put.

Thanks for all.

Good day.

This message has been edited. Last edited by: <Kathryn Henning>,

Isma,

Your code is strange.

  
COMPUTE FIELD/D12.2 = IF FIELD EQ '' THEN '--' ELSE FIELD ;

What is the original format of FIELD? Alpha? Numeric?

Try this code -

TABLE FILE EXPENSES
SUM COMPUTE FIELD/A12 = IF FIELD EQ 0 THEN '--' ELSE FPRINT(FIELD, 'D12.2', 'A12') ;
BY NAME
END

T

quote:

COMPUTE FIELD/A12 = IF FIELD EQ 0 THEN '--' ELSE FPRINT(FIELD, 'D12.2', 'A12') ;

Hello tny you understand me , you solution have a 10 thanks for all

Hello danny my field have tha acept 2 format .
thanks for all

Another option, if it fits in with your report is to use MISSING.

e.g.

SET NODATA = '--'
TABLE FILE EXPENSES
SUM COMPUTE FIELD/D12.2 MISSING ON = IF FIELD EQ 0 THEN MISSING ELSE FIELD) ;
BY NAME
END