Boolean expression for field value = field value + 1

[Anonymous]

Hello Everybody,

i'm trying to figure out a Boolean expression that checks if a field got a new entry.

Sort of field = field +1

I'm trying right nowto achieve this with:

if(field=field+1,-1.0) .

Of course it's not that easy. Lol.

Anybody who can help me here?

Cheers

spijatida

[Digvijay_Singh]

Are you trying to check in load statement that the current row field value is same as previous row value or not?

If Yes, then may be something like this, used strings as of now just for readability -

if(field=previous(field),'OldEntry','NewEntry') as Somefield

[Anonymous]

Actually I try to use that in the condition field when creating alerts