Display Date when Balance-on-Hand is less than zero (first occurance)

[jerryr125]

Hi - 

I have the following formula in a KPI :

=MIN(($(vBOHProductFinal))-aggr(Rangesum(Above(($(vForeCastProductTotal)),0,RowNo())),PSALECALENDARDATE))

This displays the FINAL negative value of the BOH Products over the dates (one year of dates)

I would like to display the actual date when the BOH Product goes from positive to negative.

Thoughts ? 

Thanks - Jerry

[jerryr125]

Hi - I am still stuck on this one - any thoughts / luck ?