Null in case of last record when next() is used. 2

[manishsawant]

Hi,

I have written a formula for displaying a value after comparing the next value. The formula is :

if {StandardAlignmentMCS.CoreObjId} = next({StandardAlignmentMCS.CoreObjId}) and isnull({StandardAlignmentMCS.MCSLocation}) then
(
""
)
else
(
{StandardAlignmentMCS_ttx.CoreObjId};
);

All the values are getting displayed properly but i am getting a blank last value. I dont know how to compare in case of last record.

I would appreciate if anyone can give some solution.

Thanks,
Manish

 

[Reebo99]

I think this should help:

If OnLastRecord then {StandardAlignmentMCS_ttx.CoreObjId} else
if {StandardAlignmentMCS.CoreObjId} = next({StandardAlignmentMCS.CoreObjId}) and
isnull({StandardAlignmentMCS.MCSLocation}) then ""
else {StandardAlignmentMCS_ttx.CoreObjId}


Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[manishsawant]

Hi Reebo,

Thanks for the suggession i didnt know about OnLastRecord funtion. It worked well.

Thanks again,
Manish