Hello,
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.
Thanks,
François
Hi Francois,
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.
Parameters:
Return value: a new string containing only letters and digits
Example: @alphanum(12345%%abc)@
Example result: 12345abc
Best regards,
Taylor
Hello Taylor,
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
Thanks
Francois
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).
Cheers!
Les
try this
@element(~Number~,".",1)@
or
@round(~Number~,0)@