Replicating the attached excel formula in QV.

[#1]

Hi Everyone,

Can anyone help me in replicating the attached excel formula in Column G in QV?

[anbu1984]

Can you post sample excel file

[Gysbert_Wassenaar]

Try =RowNo()

[danieloberbilli]

Try something like

[kavita25]

Please post a sample excel file...and is this formula is fixed for  G9  only or whole column G ???

Regards,

Kavita

[jonathandienst]

In script, use Peek and/or Previous to fetch the row above, something like this:

If([Sold-to-Party code] = '', '',

     If([Sold-to-Party code] = Previous([Sold-to-Party code]), Peek(ATMPG) + 1, 1))

As ATMPG

[Gysbert_Wassenaar]

That's assuming the fields are part of the same table. If they are then if(len(trim([Sold-to-Party code])),autonumber(ATMPG,[Sold-to-Party code]),'') would do the trick as well I reckon.