Wrong Calculation when using selective access


Hi Anaplanner,


I have module like a picture



In module Final I'm using list level 3, and I give user selective access in level 1(Indonesia), and in the module group amount I take amount form module final and sum by variable, so why amount in group amount not the same with module final?


Thank you

Best Answer

  • ArunManickam

    SUM function does not work based on selective access. You will have to think about a different solution, for eg, you could add Country as a dimension in your Group amount module.