Focal Point
[CLOSED] Compute Across Data

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3217064426

September 25, 2012, 02:45 PM
Candice1284
[CLOSED] Compute Across Data
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
Good One 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