I got a really easy exercise actually.
I want to calculate with the NEXT Value
TABLE FILE CAR
COMPUTE LASTBODY/A20 = LAST BODY;
LAST Works great, NEXT doesn't.
In the end I want to calculate
COMPUTE LOG/D12.9 = LOG(VALUE1)/LOG(NEXT VALUE1)
Hopefully someone can help.
Thanks!!This message has been edited. Last edited by: FP Mod Chuck,
Windows, All Outputs
NEXT value is not something available because the "next" value does not exist in the matrix (not yet read) so it cannot be referenced when the LAST (previous one) does.
So you need to take it the other way.
Can it not be : COMPUTE LOG/D12.9 = LOG(LAST VALUE1)/LOG(VALUE1);
Not knowing your data structure and the objective of using a "NEXT" value is difficult to provide you with a proper solution.
WF 7.7.05M, 8.1.05M, 18.104.22.168M gen240 Windows, HTML, Excel, PDF
In Focus since 2007
jenni, I know your example does not have a BY phrase, but when using LAST, this implies a specific sort order, so, have you tried reversing the sort? For example if you data is sorted by date, sort by highest date instead. When sorted this way, by definition, the most recent record does not have a next value, but now the "Next" value for row 2 is the "LAST" value.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
LAST ... NEXT... It all depends on your point of view: BY...
Good one John!
|Powered by Social Strata|