I have one across field that has two pieces of data: 06/30/2012 and 09/30/2012. How can I compute the difference of the two dates in a column shown after the across data?This message has been edited. Last edited by: Kerry,
excel
September 26, 2012, 11:51 AM
PBrightwell
If you know your column numbers, you can put a compute after the across statement. Something like:
SUM PROFIT ACROSS QTR COMPUTE DIFF/D12.2=C2-C1;
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes
September 27, 2012, 09:05 AM
Doug
Patricia, That's about as succinct as it gets.
September 27, 2012, 09:37 AM
PBrightwell
Thanks, I was trying to keep it simple and not confuse a newbie. You know as well as I that this can still be done even when you have more than 2 quarters (an unknown number) but the logic becomes much more complicated.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes