Skip to Content
avatar image
Former Member

What EPM function to use

image.pngHi ,

I have created an input form and I entered data for every activity. I would like to know what EPM function to use in ordre to display the total of activity in a Excel cell

image.png (19.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Mar 09, 2017 at 11:27 AM

    Create EPM report with Activity in the row. What is the issue? Please read basic help on EPM!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 12:02 PM

    There is no EPM Function which totals/sum up the data. Use Excel function (=SUM) to do so...using a local member.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2017 at 09:21 AM

    Ok. If I use Excel function (=SUM), can I have an example of this ? What hierarchy to use PARENTH1 or ID member?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2017 at 09:32 AM

    FOR PARENTH1=TOT_ACT of the activity i will choose

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2017 at 10:28 AM

    For example I want to display the total of amount entered fir the activity with ID 1 in a cell, what can I do?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2017 at 11:01 AM

    Hello, I want to display the total of amount entered for the activity with ID 1 in a cell, what can I do?image.png

    Add comment
    10|10000 characters needed characters exceeded

    • And what is the issue???

      Just select in the report row axis ID 1 for Activity dimension

      Please start reading help! Unfortunately I will have to alert moderator on your questions...