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,

I suggest you read the chapter on "Creating Financial Reports With Financial Modeling Language (FML)" of the "Creating Reports With WebFOCUS Language" manual.

Great suggestion. I created the report using FML, but I need to be able to change the format of the first column as follows:

rows 1-6 - D20 or I11C
rows 7-26 - D20.2CM
rows 27-28 - D12.1

Is this possible? Thanks.

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').... 

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.

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.