YTG & YTD Calculation by using custom list

Ashutosh
Ashutosh
in Modeling

Hi All,

I've one use case where I've create list which includes YTD & YTG as list item.

Then I've create a mapping module between Time & YTD & YTG list item as shown in below screenshot.

image.png

But when I am using sum to get data which is dimensioned by YTD & YTG List, result is showing 0.

Can anyone explain why I am getting 0 values after using sum.

image.png

N.B I've achieved this by using timesum later but needs to understand why sum is not working after having mapping between time & list.

Thanks

Ashutosh

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @Ashutosh

    Because Time doesn't have a top level and your target doesn't include Time. The same thing would happen if you had a list with members A, B, and C (in place of your time) and that list didn't have a top level.

Answers

Categories