Date not pulling through

CommunityMember113484 · 2023-09-27T09:45:28+00:00

There was an error rendering this rich post.

CommunityMember113484

I've got one module with data - timescale by quarter and 2 lines:

Early repayment period - quarter format
Early repayment date - date format

Then I've got another module, no timescale, with 2 lines:

Early repayment period - quarter format - formula to link to the module above: C_Early Repayment Period.Early Repayment Period[SELECT: TIME.All Periods] - this is okay.
Early repayment date - date format - formula to link to module above: C_Early Repayment Period.Early Repayment Date[SELECT: TIME.All Periods] - no data pulls through. I've tried changing the summary method to last non blank/first non blank etc, but this does not work

Can someone please assist?

Thanks

Accepted answers

anirudh

It looks like you've set the summary method on the target line item!

Can you apply this same summary in the source line item instead. The line item named Early Repayment Date in the module C_Early Repayment Period

All comments

anirudh

Formula looks correct at first glance. Only thing I want to confirm is that if summary method of C_Early Repayment Period.Early Repayment Date is set to First/Last Non Blank?

A screenshot (with no sensitive data displayed) would help!

CommunityMember113484

Yes, have tried first non blank / last non blank, max nothing. Screenshot below,

Thanks!

anirudh

It looks like you've set the summary method on the target line item!

Can you apply this same summary in the source line item instead. The line item named Early Repayment Date in the module C_Early Repayment Period

CommunityMember113484

Ah yes, I see now. I had the summary on the source for period, but not date!

That's now worked, thank you!

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…