Timesum check

CommunityMember11
CommunityMember11
in Modeling

I want to do a timesum for a value from first month of current year to last month of current but it is not returning value.

I have used logic as TIMESUM(Amount,First month of CY, Last month of CY,SUM)

Where amount is value, first month of CY is Jan 25 and last month of CY is Dec25.

Amount line item has time on whereas for timesum line item time in not applicable

Can somebody help me?

Answers

  • lokeshm
    lokeshm

    @CommunityMember11 I think Problem is with the First month of CY, Last month of CY line item .They should exclude Time dimension. Then the Time sum will works

  • CommunityMember11
    CommunityMember11

    @lokeshm - then how to get first month and last month of CY if we have to remove time scale from it?

  • lokeshm
    lokeshm
    image.png

    write the formulas in the First month and last month or else add it manually.

Categories