Lets say I have

  SUM
 Num1
 Num2
 COMPUTE cNum3/D12.2 = C1 + C2;
ACROSS Flavor 

CNOTATION works and C1, C2 point back to Num1, Num2.

is there an "ANOTATION" that allows me to refer back to the different levels of an Across field?

This message has been edited. Last edited by: <Kathryn Henning>,

What is it that you're attempting to do here, with different levels of an Across field?

You can refer to the columns by the field name instead of the notations (C#, N#,etc). Or, C#(#), where the 1st # is the column and the 2nd# is the occurrence.

You can post more code, using an IB sample file, within the </> brackets as seen above.

akin to the above case; I compute a subtraction of 2 fields. I have:

 SUM
     Ledger_Amount/D12.2B AS 'Actual'
     Budget_Amount/D12.2B AS 'Budget'
     COMPUTE Variance/D12.2B = Ledger_Amount - Budget_Amount;
     COMPUTE Variance_Pct/D12.2% = 100 * ( ( Ledger_Amount - Budget_Amount ) / Ledger_Amount ); AS '% Variance'
BY  GL_Account_Finance_Tree_name HIERARCHY
BY  Date_Calendar_Month NOPRINT
ACROSS LOWEST Date_Date_Calculation
ulation EQ 'MTD' OR 'QTD' OR 'YTD'; 

in another case I want to compute subtractions across levels of the across field. ie) Ledger_Amount this year - Ledger_Amount last year.

   SUM
     Ledger_Amount
     COMPUTE Test1/D12.2B = C1 - 1;
BY  GL_Account_Finance_Tree_name HIERARCHY
BY  Date_Calendar_Month
WHERE Date_Date_Calculation EQ 'MTD' OR 'MTD LY' OR 'QTD' OR 'QTD LY'; 

Because I am using a cube I run into issues when I try to define/compute
IF Date_Date_Calculation EQ 'MTD' THEN Ledger_Amount ELSE 0

namely, it forces Date_Date_Calculation to act as a by field regardless of its absence in the code. If I use a hold file and Sum to account for the resulting zeros then I lose the Structure of the GL_Account_Finance_Tree_name HIERARCHY...

quote:

If I use a hold file and Sum to account for the resulting zeros then I lose the Structure of the GL_Account_Finance_Tree_name HIERARCHY...

Not worked in cube so far, however just here to say that after holding a file, you can refer a columns using E01, E02 ...

Nicholas,
Welcome to the Forum. Please update your signature with version of WF etc.

quote:

SUM
Ledger_Amount/D12.2B AS 'Actual'
Budget_Amount/D12.2B AS 'Budget'
COMPUTE Variance/D12.2B = Ledger_Amount - Budget_Amount;
COMPUTE Variance_Pct/D12.2% = 100 * ( ( Ledger_Amount - Budget_Amount ) / Ledger_Amount ); AS '% Variance'
BY GL_Account_Finance_Tree_name HIERARCHY
BY Date_Calendar_Month NOPRINT
ACROSS LOWEST Date_Date_Calculation

Beware when you reformat a field within the TABLE request: for each reformatted field you will have 2 internal fields and this impacts the C-notation.

Will do.

Interesting, I think I was running into that. Thanks for the heads up.

 C#(#), where the 1st # is the column and the 2nd# is the occurrence. 

whats is second occurrence referring to? a different level of across? If so this may work otherwise I think I will have to play around with the SASS ENGINE SET.