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.
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).
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
Retrieving data ...