TIMESUM syntax error
Hi everyone !
I am currently doing the Level 2 Model Builder, Sprint 1, and I am stuck at step 1.5.7
Basically, I need to feed a boolean Line Item called "Has Data?", which is on the SKU ; Account dimensions from a numeric Line Item called Volumes, which is on SKU ; Account ; FY19 dimension. Therefore, I need to aggregate the data on the time dimension, using a ANY aggregation method to retrieve a boolean value.
Here is how I try to feed "Has Data?":
TIMESUM('DAT03 Historic Volumes'.Volumes , , ,ANY)
or
TIMESUM('DAT03 Historic Volumes'.Volumes, From, To, ANY)
and even
TIMESUM('DAT03 Historic Volumes'.Volumes [,] [,] [,ANY])
None of these worked, I'm stuck...
Here is what I found on Anapedia :
TIMESUM(Line item to aggregate [, Start period] [, End period] [, Aggregation method])
Start Period & End Period are non mandatory values according to Anapedia. However, missing intermediate parameters are not permitted. I'm not sure what's that suppose to mean...
Thanks in advance for your kind help !
Benoît
Comments
-
Thanks @Adam !
Here is the formula I used :
Has Data? = IF TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 THEN TRUE ELSE FALSE
It works just fine.
0
Categories
- All Categories
- 2.3K Anaplan Community
- Academy
- Anaplan Talent Builder
- Model Design Course
- The Anaplan Way
- Archive
- 2 Idea exchange
- 62 Enterprise Scale
- 1.1K Extensibility
- 21 Intelligence
- 1.6K Planning & Modeling
- 331 Security
- Community Connections
- Connections
- Experiences
- Groups
- Personas
- Employees
- CS Toolkit
- Customer Care Center
- Forums
- Academy & Training
- Community Feedback & Updates
- Japan
- Anaplan Community Japan
- Anaplan Community Japan Knowledge Base
- HyperCare Japan
- JP-Central
- Support-Japanese
- Partners
- Partner Leadership Council
- Partner Product Council
- 724 Platform
- Anapedia
- App Hub
- Centers Of Excellence
- Extensions
- Planual
- Platform Updates
- 724 User Experience
- Profile Builder
- Resources
- Anaplan Advocates
- Anaplan Live!
- Community
- Community Advancement
- Community Connections
- Partner Program
- The Official Master Anaplanner Program
- Videos
- Welcome to the Anaplan Community!
- Success Central
- Support
- Case Portal Link
- Common Support Questions
- HyperCare Redirect
- Known Issues and Workarounds
- Support test page
- SupportFAQ
- Survey
- 2 Training Day Takeaways