Hi, thanks for getting back. Do you mind explaining this a bit further? I think I get it conceptually, but in terms of the formulas, not quite there! I've got a new module which is time period formatted (quarter) for last input. But I'm struggling with the last nonblank formula - how do I get the period in which someone has input data?
Hi, thanks for your input. Sorry, I'm still a bit confused. So I actually tried in the original reporting module to change all summaries to the last non-blank but it didn't work with certain line items e.g. when datatype is NUMBER?
In terms of the module I created to find the last input, I was able to set the summary to last non-blank and this was able to get me the last nonblank item, but it didn't quite tell me which period was the last non-blank to do the lookup on?
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 - thanks for your help. I've managed to get the last non blank in text format. But in terms of this - 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. - do you mind stepping through how to do this? Thanks