Timesum check

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?

Accepted answers

All comments

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

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

lokeshm

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

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…