Required "H" & "S" on less or greater value

Hi Team,

As per the below data we do have the amounts in positive and negative value, with the help of this we required "H" & "S", if amount is in negative then value it will come as "H", in positive value it would be "S".

Amount	Required Detail
-54	H
-43.1	H
56.92	S

Regards,

Mahesh

Developer Tools

Accepted answers

ShankerV

Hi @Maheshp

Please use Formula tool.

Formula tool settings:

Output column: Output

IF Contains(ToString([Amount]), '-')
THEN "H"
ELSE "S"
ENDIF

Data type: V_String

Many thanks

Shanker V

All comments

ShankerV

Hi @Maheshp

Please use Formula tool.

Formula tool settings:

Output column: Output

IF Contains(ToString([Amount]), '-')
THEN "H"
ELSE "S"
ENDIF

Data type: V_String

Many thanks

Shanker V

Maheshp

Can you please provide the complete formula, along with <> zero as this is creating the confusion.

dwstada

that is the complete formula

it turns the number into a string, then looks if there is a "-" in it (so for all negative numbers) and asigns "H" to those records, all the others get an "S"

Qiu

@Maheshp
Can we simply use below?

IF [Amount]<0 THEN "H"
ELSEif [Amount]<0 then "S" else "Check"
ENDIF

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703