Average of a calculated field

hrnickel

Hello,

how I am able from a calculated value (formula)
Column A the average calculate.


A := Sum(Field1)
B := Sum(Field2)
C := Calculate (A+[img]style_emoticons/<#EMO_DIR#>/cool.gif" style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> D := Calculate average from C Please, an example. Thanks[/img]

-=Oleg=-

Hi.

You can do it in FastCube 2.

1. Create simple "sum" measures 'A' and 'B'
2. Create calculation measure 'C' with script:
result := measures.currentvalue + measures.currentvalue;
3. Set function for total in measure 'C' as "average"


Best regards,
Oleg Pryalkov.

hrnickel

wrote: »

Hi.

You can do it in FastCube 2.

1. Create simple "sum" measures 'A' and 'B'
2. Create calculation measure 'C' with script:
result := measures.currentvalue + measures.currentvalue;
3. Set function for total in measure 'C' as "average"


Best regards,
Oleg Pryalkov.

Data output should explain of following end

A B C D
1 5 6 9
2 6 8 9
3 7 10 9
4 8 12 9 = average from C

Please help me

Xavi

As suggestion for a future version, I would ask you to be able to enter directly the expression, in the properties option, not indirectly calling a function that then you need to call.

-=Oleg=-

Hi.

We plan to do it in future.

Best regards,
Oleg Pryalkov.