Truncate (NOT ROUND) decimal numbers in Azure Data Factory Mapping Data Flow

Viewed 716

Do you know a way of truncating decimal numbers (not round) in mapping data flow in Azure Data Factory?

Example:

Input: 123.456

Output: 123.45 (not 123.46)

1 Answers

The answer is round(123.456,2,4) --> 2 is the post characters, 4 is the round option - FLOOR

Related