Remove Decimal Point

[EvansM]

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 solution]

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 solution]

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

[EvansM]

@Simha Thank you very much for your help. Please refer again the attached image. I like your solution but doesn't address the second scenario. I attached a data sample this may help a little.

Again thank you very much for your help

[EvansM]

@DiegoParker  Thank you very much for your help. I am still running the workflow I will keep you posted.

[danilang · Accepted solution]

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 solution]

@danilang Thanks a lot this  works like a champ.