Hello all,

Is there and Excel format I can use to display subfoots in the Excel output??

Thanks!

WF 7.7 Z/OS mainframe Excel 2013

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

TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"WHATEVER YOU WANT TO PUT IN HERE"
ON TABLE PCHOLD FORMAT XLSX FORMULA
END

WF will send to Excel any heading, sub-heading, footing, sub-footing, total, sub-total that you've added to your report without any specific Excel format.

Having "... FORMULA" does only send also the formula and not just the data.

Is this what you're looking for, it is not clear for me ?
Because the answer to your question

quote:

Is there and Excel format I can use to display subfoots in the Excel output??

is No, any Excel format will includes the subfoots DATA/VALUES. If you also need HOW it has been calculated, then you need to add FORMULA as suggested by BabakNYC.

If this answers your question, please edit your first port and add [SOLVED] to the title.

Solved -- How do I edit my original post?

Nevermind, I found it