Find the first positive value in the row and count the previous negative values

[#1]

Hello,

I have some problem, I have a data set about customer and want to calculate landing time, if not want to say not landing

data set :

Thank you very much

customer	2016-01	2016-02	2016-03	2016-04	2016-05	2016-06	2016-07	2016-08	2016-09	2016-10	2016-11	2016-12	result
a1	-	-	-	-4284280	-4819475,97	-5454904,62	5876117,87	6369789,83	6836207	7360405	7944499,94	8519044,45	3
a2	-3	-5	-7	-5	9	15	30	4
a3	-3	-5	-5	-5	-5	-5	-5	-5	-5	-5	-5	-5	"NOT YET"

[sunny_talwar]

In the script or front end of the application?

[#3]

Front end of the application

[sunny_talwar]

Would you be able to share a sample where you are trying to do this?

[#5]

I added an Excel sheet

Have an 100 customer want to calculate when a customer become + like result column

[#6]

Trying to do in qlikview; I have an data set like added Excel sheet

[Anonymous]

Something like this?

Would there be negative numbers after there are positive numbers?

[#8]

yes there would be negatif numbers after positife but,

it is important for me to count only the negatif values before first positive number

[#9]

Pavan Thanks for your help, but I want to calculate only the negatif values before first positive number ,

if there would be negative number after positive number, it is not counted, can you help ?

[#10]

i there anybody wants to help me

it is so important for me