You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data loaded from DM not behaving as expected for YTD and PRD

edited Apr 29, 2020 10:41AM in Financial Consolidation and Close 6 comments

Content

Hi all

We are loading data from DM in YTD data (FCCS_YTD_Input), then these data is transferred automatically in FCCS_YTD member and the system calculates FCCS_Periodic member.
 
The issue is when we have no data in a month, we expect to see YTD data displaying as 0.
 
example:
- In January account B is 50€ (in the first month always FCCS_Periodic and FCCS_YTD are the same)
- In February we load in account B 75€ in FCCS_YTD_Input, then, FCCS_YTD will be 75€ and FCCS_Periodic will be 25€
- In March we don't load ANY DATA, so we expect to see in
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!