Does anyone have a suggestion on how to create the sample report? The numbers, dollars and percents are the calculations for labels (ASNAMES) in the first column. I am using Dev Studio 8007, IE version 11, Windows 7. Thank you.
Title Name Feb 2015 Jan - Feb 2015
# % # %
Total Bills 1,234 % of Bills 1,234 % of Bills
PPO 1,234 0.0% 1,234 0.0%
Non PPO 1,234 0.0% 1,234 0.0%
Total Lines 1,234 % of Lines 1,234 % of Lines
PPO 1,234 0.0% 1,234 0.0%
Non PPO 1,234 0.0% 1,234 0.0%
$ % $ %
Total Provider Charges $1.00 % of Charges $1.00 % of Charges
PPO $2.00 0.0% $1.00 0.0%
Non PPO $3.00 0.0% $1.00 0.0%
Savings $1.00 % of Savings $1.00 % of Savings
Fee Schedule/UCR $1.00 0.0% $1.00 0.0%
PPO $1.00 0.0% $1.00 0.0%
UR $1.00 0.0% $1.00 0.0%
Duplicate Charges $1.00 $1.00
Recommended Allowance $1.00 $1.00
Total Fees $1.00 % Fees $1.00 % of Fees
Bill Review $1.00 0.0% $1.00 0.0%
PPO $1.00 0.0% $1.00 0.0%
Total Net Savings $1.00 $1.00
Average Cost per Review $1.00 $1.00
Gross ROI 1.1 1.1
This message has been edited. Last edited by: Michele Brooks,
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 12, 2015, 12:28 PM
j.gross
I suggest you read the chapter on "Creating Financial Reports With Financial Modeling Language (FML)" of the "Creating Reports With WebFOCUS Language" manual.
- Jack Gross WF through 8.1.05
February 13, 2015, 10:11 AM
Michele Brooks
Great suggestion. I created the report using FML, but I need to be able to change the format of the first column as follows:
Change the first column field into an Alpha using FPRINT and change the format to the one required, e.g.
DEALER_FMT/A30 = IF CAR EQ 'AUDI' THEN FPRINT(DEALER_COST,'D20','A30') ELSE
IF CAR EQ 'JAGUAR' THEN FPRINT(DEALER_COST,'D20.2CM','A30')....
Alan. WF 7.705/8.007
February 13, 2015, 01:57 PM
Michele Brooks
The first column is not a field, it's a label for numeric fields of which I have no idea of what the values are. Thanks.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
February 18, 2015, 05:50 PM
Michele Brooks
quote:
Originally posted by Alan B: Change the first column field into an Alpha using FPRINT and change the format to the one required, e.g.
DEALER_FMT/A30 = IF CAR EQ 'AUDI' THEN FPRINT(DEALER_COST,'D20','A30') ELSE
IF CAR EQ 'JAGUAR' THEN FPRINT(DEALER_COST,'D20.2CM','A30')....
My apologies. Your suggestion is an excellent one. I did something similar to what you posted, but your technique is perfect. Thank you so much, and again my apologies for not fully understanding. I am closing this case as solved.