How to copy an expression value to a different table

[Anonymous]

Hello!

Hope someone could help me on this...

I have a rangesum formula from a  different pivot table...

RangeSum(alt(Before(TOTAL [Gross Forecast]), 0), sum({$<Term = {'Supply'}>} Qty) - sum({$<Term= {'Demand'}>} Qty))  with field label [Gross Forecast]

Now I'd like to create a new pivot table and create an expression value to get the value from the other pivot table and multiply by 50%

I tried   using  [Gross Forecast] *.5 but doesn't work

I also tried  using 2 expressions

   where 1st ex   label as Forecast

RangeSum(alt(Before(TOTAL [Gross Forecast]), 0), sum({$<Term = {'Supply'}>} Qty) - sum({$<Term= {'Demand'}>} Qty))  with field label [Forecast]

and 2nd expression    as   Forecast *.5  but still doesn't work.

Is there any way to do it?

Pls. advise.

Tks

[swuehl]

You can't access the expression values of one table from within another table.

You would need to replicate the expression values in the second table, if the dimensions of both tables differ, you can use advanced aggregation to create a 'virtual table':

AGGR...