Script like cumuletieve

[#1]

Hi all,

Can you please explain how to implement bellow one.

XP

--------

1-(1-current record)

1-{(1-prev result)*(1-current record)}

:

:

:

:

And so on n th record

XP is field name

[#2]

Here i have the separate field for current , next recods.

Sales rate

-------------------

1

2

3

4

6

8

:

:

:

And so on n th record

Using this need to calculate in qv script.

Thanks.

[sunny_talwar]

What is the expected output here?

[miguelbraga]

Hi there,

Do you have any kind of data that you want to implement this rate? Creating this out of nowhere to me seems dificult. Can you please attach a QVD or a QVW or even specify what for you need this rate?

Regards,

MB

[settu_periasamy]

Try like

If (rowno()=1,1-fieldname,(1-peek(XP))*(1-fieldname)) as XP