Average of a calculated field

edited October 2013 in FastCube
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]

Comments

  • edited 11:56AM
    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.
  • edited 11:56AM
    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


  • edited 11:56AM
    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.

  • edited 11:56AM
    Hi.

    We plan to do it in future.

    Best regards,
    Oleg Pryalkov.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.