How to bring in previous balance into current module? Or how do I bring in a rolling balance forward
Options
kdoan
Member, ALL USERS, Community Member Posts: 5 Contributor
I am creating a balance sheet. I am hoping if anyone can show me the best approach. I have two module.
Previous balance module and current Balance sheet module.
My previous balance module have no time scale. I want the previous Ending balance in my current module. I attached 2 screen shot to show you what I mean. When I try to add them together, my previous balance module add it to each month. How do I include my previous balance amount without it affect my current month?
Example
FY18. Ending Balance = 100
Jan 19 = 20
Feb 19 = 20
Mar 19 = 20
Q1 FY19 = 160
Apr 19 = 20
May19 = 20
June19 = 0
Q2 FY19 = 200
0
Comments
-
@LipChean_Soh Thank you. It worked.
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