Please help me figure out a way to display D14 JPY and D14.2 currency in the same field. Thanks!

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

Hi Welcome to the forum,

You can have a second field with the format desired and apply it to the display field.

e.g.
DEFINE FILE CAR
CURR/A8 = IF COUNTRY EQ 'JAPAN' THEN 'D15:Y' ELSE 'D15M';
END
TABLE FILE CAR
PRINT DEALER_COST/CURR
BY COUNTRY
END

quote:

Originally posted by Waz:
Hi Welcome to the forum,

You can have a second field with the format desired and apply it to the display field.

e.g.
DEFINE FILE CAR
CURR/A8 = IF COUNTRY EQ 'JAPAN' THEN 'D15:Y' ELSE 'D15M';
END
TABLE FILE CAR
PRINT DEALER_COST/CURR
BY COUNTRY
END

Thanks so much for your response! I tried this method earlier and I keep getting a FOC1130 format conversion error for D14.Y and D14M
I only have access with InfoAssist so I am creating a define field with CURR/A8 and then defining the DRAWAMT D14.2 field as DRAWAMT/CURR....resulting in the foc1130 errors. Thanks again!