i want to convert this positive value to negative value, in the expression.
I use this value in the expression, but the value still positive and does not change to negative
Hello Marhta,
Please check the below .oml file, I have created one demo for this, Hope this will help.
Regards
Wut?
Just make another if and check if is >0 and if it is multiply by -1
it doesnt working
Can you please try the following option.
1) Please check if BasicWages is type of Integer.
2) After that try to its Division by -1.
3) use this (Texttointeger(replace(BasicWages,",","")))/-1
thankyou.. i will try it..
thank you, its done .. :D
But what is the solution now? I'm curious
Hi Marhta
Check if the value >0 then multiply by -1. If 0 or <0 you do nothing.
First check if the values is really made negative.
You can do that with placing the value as a simple expression on the screen, or check it while debugging.
If the conversion is correct, then add the correct format like described above eg. FormatCurrency or FormatDecimal or DecimalToText with any replaces etc.
Maybe start with the source ... What is the datatype of the attribute and what is it's value in the database?
Hi Mahrta,
No need to check for negative and multiply by -1. There's the built-in Abs() function that converts a number to its absolute value. Just use Abs(RecordSummaryFLC.Current.BasicWages).