CEIL(RecordID/2) Stops Working at RecordID 511

[hellyars]

I have a simple formula  CEIL(RecordID/2).   It stops at RecordID 511.

RecordID	Group = CEIL(RecordID/2)
509	255
510	255
511	Null
512	Null

[AngelosPachis · Accepted solution]

Hi @hellyars ,

Check the data type of the field "Group". I think that would be a Byte, so that's the reason it can accommodate values until 256.

If that's the case, change that to an Integer (Int16,32 or 64 would work).

Hope that helps.

Regards,

Angelos

[pedrodrfaria]

Hi @hellyars 

Could you please upload the workflow you are talking about? Or at least the sample you mentioned?

You should not be getting any errors unless the recordid column is not properly formatted. Make sure the data type is something that accommodates more than 250 characters.

[hellyars]

@AngelosPachis   You are correct.  It was set to Byte.  Easy fix.  Many thanks.