Identify Decimal Records

CommunityMember11

Hey Team, I have a small doubt.

User has entered some records in a module out of which some of them are decimal records like 1.5 or 2.5 and some are 1 or 2.

Here I need to identify those records which have decimal in them?

Also, I was thinking it to make 1.5 as 1, 2.5 as 2 and leave 1 and 2 as it is since it is not decimal.

I tried round function but couldn't achieve it.

Can somebody help me on this?

MiguelGG

Hi there!

In case your decimal numbers are always like "1.5", you can use the following formula (I am assuming you use the Classic engine, if you use Polaris just remove the EXACT argument, as Polaris uses always the exact method):

Rounded Value: ROUND(Value, 0, DOWN, EXACT)

Where "Value" is the record entered manually. This will automatically round 1.5 to 1, 2.5 to 2, and so on.
Keep in mind that if other decimals are allowed, they will also be rounded down (e.g., 1.9 would be rounded to 1). So if you expect values like 1.9, 1.8, etc., you might need to apply a workaround.

To identify which line items have a decimal part, you can use the Rounded Value line item and then write:

Is Integer : Value = Rounded Value

This line item will return true for integer numbers and false for non-integer numbers.

Here’s an example:

Let us know if this works for you.

Miguel.