Remove Decimal Point

Question

Hello Community,

Please refer to the attached image. I need help to create the formula for the scenario highlighted In Red on the attached image.

Thanks

DiegoParker · Accepted Answer

Hi @EvansM

The idea would be something like this.

Input

Output:

The formula goes:

IF [   SERVICE*   ]=1 OR [   SERVICE*   ]=4
THEN
Round([Test], 1)
ELSEIF [   SERVICE*   ]=2
THEN [Test]*1000
ELSE
[Test]
ENDIF

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego

Simha · Accepted Answer

Hello,

Without knowing much about the requirement and not having data, I have tried to put a quick solution, if that helps.

Hope this helps a bit.

Regards

Simha

danilang · Accepted Answer

Hi @EvansM

You should be able to use this in a formula tool

if [SERVICE_NUMBER] in (1,4) then
	FLOOR([READING])
Elseif [SERVICE_NUMBER] = 2 then
	FLOOR([READING]*1000)
else
	[READING]
endif

The Floor() function truncates the number to next lowest Integer.  2.25->2, 9.55->9, etc.

Since you've only got 2 columns to modify, repeat this formula for the Consumption as well

Dan

EvansM · Accepted Answer

@danilang Thanks a lot this  works like a champ.