Formula returning the date \ month of first data in line item

Options
AnotherMonday
AnotherMonday Member, ALL USERS Posts: 1 New Contributor
in Planning & Modeling

Hey Anaplaners,

 

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. 

 

Any ideas how this can be possible? 

 

Tagged:

Categories