Formula returning the date \ month of first data in line item
so my need is to create a formula that will go through the line item, that has a monthly timescale (that line item is filled in as numbers by the user) and return first month \ date (date better), when the data is met in the line. So it kinda scans and whenever meets "non-zero value" - gives me the time of that value.
Re: Formula returning the date \ month of first data in line item
Could you post a worked example showing the data and the expected result? Using a time module one can certainly easily identify the first month in a timescale, but I'm not sure that that is what you need here