URGENT calculation Help !
Using FM 12 pro advanced.
Problem: here I have tried to explained in the picture.
The problem is i can not make " Late days" in 10 but it keep coming as -10 " as that will be used for invoice
the Abs ( ) function could help.
Abs as ? Sorry but i am bit Noob in this if i could get help in bit detail would be great please
Enclose that part of the calclulation, (I can't tell which part is produces the -10) inside a call to the absolute value function:
AbS ( 10 - 20 )
will return 10 instead of -10.
You may also be able to use data formatting in the inspector to hide the - symbol.
Inspector : Data been on there but can not find anything to hide that - symbol.
There are actually several formats that do not use the -, but since they then use other characters, such as enclosing the value in parenthesis to show that it is negative, they probably won't work for you.
But I also suggested that you modify your calculation to remove the -, such as using the ABS function. But you'd said very little about the calculation and how you need it to work, there are two parts of your If function, for example that could produce a negative value and you haven't explained if one specific "branch" of the calculation or both are producing the negative value.
Retrieving data ...