Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Field with both JPY and USD`
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Field with both JPY and USD`
 Login/Join
 
Member
posted
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,
 
Posts: 2 | Registered: April 27, 2020Reply With QuoteReport This Post
Expert
posted Hide Post
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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6325 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
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!
 
Posts: 2 | Registered: April 27, 2020Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Field with both JPY and USD`

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.