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] Different currency on every line
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Different currency on every line
 Login/Join
 
Platinum Member
posted
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,


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 112 | Registered: August 29, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Define a field with the format you want and use it in the TABLE request as described here:
http://forums.informationbuild...751082532#5751082532


WebFOCUS 8206, Unix, Windows
 
Posts: 1660 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
it works
thnx


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 112 | Registered: August 29, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Different currency on every line

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