Is there a function in TDM to remove the decimal part of a division.
I don't want to use the round function because it rounds up.
Can you please provide an example of what you are trying to do and the data that needs a decimal removed?
The Datamaker function ALPHANUM(STRING) removes all non-alphanumeric characters from a string. Would that help?
Remove all non-alphanumeric characters from a string.
Return value: a new string containing only letters and digits
Example result: 12345abc
Here is an exemple.
I have a division : 467627 / 26 = 17985.65384615385
I need to remove the decimal from the result = 17985
I can't use round because it will give me 17986
I have checked with Development. There is nothing that is available to you. However, as an enhancement, it could be added in the current GA (TDM 4.1).