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

[Maheshp]

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

[ShankerV · Accepted solution]

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