Report Assist (for Rep Obj) cant use C references?
TABLE FILE CAR SUM SALES BY COUNTRY ACROSS SEATS AND COMPUTE whatever/I8=C3-C2; END ... Report Assist doesn't seem to recognize the C reference when using The Compute button to get some margin calculation. That can't be true, can it? How do i teach users to , say, calculate a growth rate across 2 years using JUST the RA. ?
looking at the fex that gets created... RA puts the COMPUTE statement before the ACROSS, so there's no way to calculate a margin value in an ACROSS. That's just GOTTA be fixed. RA has GOT to be smart enough to deliver 2 kinds of COMPUTEs, before the across and/or after the across. Does anybody have a spark of genius?This message has been edited. Last edited by: susannah,
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 15, 2008, 04:27 PM
Leah
I've never tried it with across, but C references in computes are tied to column values, so in your example C1 is sales, so are you wanting to do it on the first two columns of the across?
Leah
May 15, 2008, 05:21 PM
FrankDutch
If you code this by hand and reopen the fex in RA the code is removed, so it seems to be not supported....
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
May 15, 2008, 05:26 PM
Prarie
RA has GOT to be smart enough to deliver 2 kinds of COMPUTEs
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
May 15, 2008, 05:31 PM
Leah
I do know that it will give a correct compute on the field names rather than column references, but I've also used column references and I'm sure it was in RA. Dev Studio has fits at times.
Leah
May 16, 2008, 10:24 AM
GrEaT_DeBaTe
Have you tried ON TABLE HOLD AS HOLD_THIS FORMAT ALPHA or even the ON TABLE RECOMPUTE option