Hello,

TABLE FILE CAR
SUM SALES
BY COUNTRY
ACROSS SEATS
END

 			SEATS 
 		2 	4	 5
ITALY  			4800  
JAPAN 			78030  
W GERMANY 		8900 	79290

It try to calculate a formulary based on 2 across columns (Column 3 div 2) :

 			SEATS 
 		2 	4	 5 	3/2
ITALY  			4800  
JAPAN 			78030  
W GERMANY 		8900 	79290 	9,91

Is-it possible ?
Thanks in advance.

This message has been edited. Last edited by: Kerry,

Yes, using FML. Look for "Creating Financial Reports With Financial Modeling Language (FML)" in the Creating Reports With WebFOCUS Language documentation or Creating Financial Reports With Financial Report Painter.

Thank you. Below the solution :

  
TABLE FILE CAR
SUM SALES
BY COUNTRY
ACROSS SEATS
RECAP
MyDiv/D6.2=C3/C2;
END

This message has been edited. Last edited by: K2R400,

You're posting a question on a WebFOCUS forum so I provided a WebFOCUS solution. With an ACROSS, a "simple divide" is not necessarily simple - what if there are more than three across columns, how would you address the individual columns?

This is what FML is for - it's not really another tool, it's an extension to the WebFOCUS code.

But since you're on DB2 Web Query, this all might be a moot point.

Sorry, I modified my previous post.
Thank you again for your precious help.

That will definitely work when you can be specific about the columns (C1, C2, C3, etc). FML is used you don't know the number of columns and for much more sophisticated stuff.

"precious"? hmmmm......