Hai

I have a selection in a report. Showing you a part below.

TABLE FILE GWTB227
SUM
COMPUTE MIS2/I1 = IF AANT20 NE MISSING OR 0 THEN 1 ELSE 0; NOPRINT
COMPUTE MIS3/I1 = IF AANT30 NE MISSING OR 0 THEN 1 ELSE 0; NOPRINT
COMPUTE TOTALCASE/I2 = (MIS2+MIS3+MIS4+MIS5+MIS6+MIS7+MIS8+MIS9+MIS10+MIS11+MIS12+MIS13); NOPRINT
COMPUTE AANTAVE/D15C = (AANT10 + AANT20 + AANT30 + AANT40 + AANT50 + AANT60 + AANT70 + AANT80 + AANT90 + AANT100 + AANT110 + AANT120) / TOTALCASE; NOPRINT
COMPUTE BEDRAVE/D15.2!E = (BEDR10 + BEDR20 + BEDR30 + BEDR40 + BEDR50 + BEDR60 + BEDR70 + BEDR80 + BEDR90 + BEDR100 + BEDR110 + BEDR120) / TOTALCASE; NOPRINT
COMPUTE AFWGEM/D15 = BEDR10 - BEDRAVE ; NOPRINT
BEDR50/D15.2!E AS 'Bedrag &COLTIT5'
BEDR60/D15.2!E AS 'Bedrag &COLTIT6'
BEDR70/D15.2!E AS 'Bedrag &COLTIT7'
BEDR80/D15.2!E AS 'Bedrag &COLTIT8'
BEDR90/D15.2!E AS 'Bedrag &COLTIT9'
BEDR100/D15.2!E AS 'Bedrag &COLTIT10'
BEDR110/D15.2!E AS 'Bedrag &COLTIT11'
BEDR120/D15.2!E AS 'Bedrag &COLTIT12'
BEDR130/D15.2!E AS 'Bedrag &COLTIT13'
BY SORT_MC_KSTN_TYP_OMS NOPRINT
BY MC_KSTN_TYP_OMS NOPRINT
BY ICA_ID NOPRINT
BY ICA_OMS NOPRINT
BY MC_SRVC_ID NOPRINT
BY MC_SRVC_OMS NOPRINT
BY MC_BILL_EVNT_ID AS 'Event ID'
BY MC_BILL_EVNT_OMS AS 'Event omschrijving'
BY MC_BILL_EVNT_MSRT AS 'Muntsoort'
ON SORT_MC_KSTN_TYP_OMS SUBHEAD

It concerns the amount fields, for instance
BEDR40/D15.2!E AS 'Bedrag &COLTIT4'

The currency (MC_BILL_CURRENCY) can be different for every line. It can be USD or EUR.

So when currency is EUR it has to be noted as
BEDR40/D15.2!E
And when it is USD it has to be noted as
BEDR40/D15.2M

How do I make this possible?

Regards
Ron

This message has been edited. Last edited by: FP Mod Chuck,

Define a field with the format you want and use it in the TABLE request as described here:
http://forums.informationbuild...751082532#5751082532

it works
thnx