Running total formula ignores first record. 1

[NBVC]

Hi All,

I have a running total in my report that evaluates based on a formula as follows:

NOT(({RECEIVER.PURC_ORDER_ID}= previous({RECEIVER.PURC_ORDER_ID})) and ({PURC_ORDER_LINE.LINE_NO}= previous({PURC_ORDER_LINE.LINE_NO})))

It works most of the time, but it omits including the very first record in the running total sum. Is there something I should add to the formula to ensure the first record is not trying to check for a previous record?

 

[fisheromacse]

the first record has no previous record, so you need to tell crystal what to do with it.

maybe something like:

IF onfirstrecord=TRUE
then
{table.fieldvalue}
else
NOT(({RECEIVER.PURC_ORDER_ID}= previous({RECEIVER.PURC_ORDER_ID})) and ({PURC_ORDER_LINE.LINE_NO}= previous({PURC_ORDER_LINE.LINE_NO})))

 

[NBVC]

I am not certain what to substitute {table.fieldvalue} with?

 

[NBVC]

I tried this, to no avail though....

if Not onfirstrecord then
NOT({PURC_ORDER_LINE.PURC_ORDER_ID}= previous({PURC_ORDER_LINE.PURC_ORDER_ID}) and {PURC_ORDER_LINE.LINE_NO}= previous({PURC_ORDER_LINE.LINE_NO}))

 

[Charliy]

Try this instaed:

if onfirstrecord or
NOT({PURC_ORDER_LINE.PURC_ORDER_ID}= previous({PURC_ORDER_LINE.PURC_ORDER_ID}) and {PURC_ORDER_LINE.LINE_NO}= previous({PURC_ORDER_LINE.LINE_NO}))

 

[pmax9999]

Try:

OnFirstRecord or
NOT	(
		({RECEIVER.PURC_ORDER_ID}= previous({RECEIVER.PURC_ORDER_ID})) and 
		({PURC_ORDER_LINE.LINE_NO}= previous({PURC_ORDER_LINE.LINE_NO}))
	)

Cheers
Pete

 

[NBVC]

Thanks Pete. That one worked

Charliy, yours prompted an error looking for "then"...