Average Of Flat List

JEEVAK
JEEVAK
in Modeling

Hello All,

                Is it possible to find average of flat list. If it is possible please help me with it.

Thankyou in Advance

Regards,

JeevaK

Tagged:

Answers

  • JohnP
    JohnP

    Hi @JEEVAK,

     

    Below is one way of finding the average of a flat list, but let me know if I've misunderstood your question.

     

    1. Create a list 'S' with only one item 'Pull'.

    2. Create a module (e.g. 'Module1') with your flat list as the dimension, and line items called 'Value' and 'Mapping'.

    3. For the line item called 'Value', leave the format as number and in the formula reference the line item of which you want to take an average.

    4. For the line item called 'Mapping', change the format to the list called 'S' created in Step 1. Reference the single item in this list in the formula, e.g. " S.Pull ".

    5. Create another module (e.g. 'Module2') with list 'S' as the dimension and a single line item called 'Average'. The formula of this line item should be " 'Module1'.Value[AVERAGE: 'Module1'.Mapping] ", which should give you the average of the flat list.

     

    Hope this helps!

     

    Best, 

    John

  • JEEVAK
    JEEVAK

    Thankyou @JohnP 

Categories