Hi
I have a module where teams input information on a quarterly basis. I then use this to pull through into a summary and compare against previous quarters etc.
However, some teams only input on an annual or half-yearly basis. In my summary, is there a way to pull through the last time teams input?
Thanks in advance,
Hi,
There are several ways to perform this.
You can for example create a time period formatted and time dimensioned line item which returns the time period if a comment is entered.
If you use the lastnonblank summary method for this line item and have All Periods activated in your time settings, you can retrieve the last period when a comment is entered.
Use this to lookup the last entered info.
I hope this helps!
Adding/reiterating on to @Axel_H suggestion.
Assuming the input module is dimensioned by Quarters/months/weeks.
1. Activate All periods from time settings
2. Refer the input line item in the line item created in new module.
3. Go to blueprint view of the new module.
4. Scroll to right in blueprint view and In the summary method select "Last non blank" for the line item in which that data is being summarised.
~Abhi
Hi @CommunityMember113484 change the number to text format in different line item and use the last-non-blank. Once you are able to find the last-non-blank then write the condition to the period saying if the value in last-non-blank is equal to any period value then get the period value.
In this way to can find the last-non-blank as well as period of the last-non-blank value.
Hi @CommunityMember113484 Create a new line item and write a formula "IF Text Format Item(line item) = Last non blank item(line item) THEN get period value. ELSE Blank