Question
Commonwealth Bank of Australia
Commonwealth Bank of Australia
IN
Commonwealth Bank of Australia
Posted: Jun 19, 2024
Last activity: Jun 27, 2024
Last activity: 27 Jun 2024 12:50 EDT
Solved
Converting 2000 to 2K and 1000000 convert to 10M in activity or DT
Hi Team,
I have requirement like if value is 2000 and want to convert to 2K and if 1000000 then 10M in activity. How can we do this in activity or DT?
Accepted Solution
Posted: 8 months ago
Updated: 7 months ago
Updated: 27 Jun 2024 12:50 EDT
Infosys Limited
Infosys Limited
IN
Define the conditions and results for suffix determination.
Example Decision Table:
Conditions (When) Result (Suffix)
InputValue >= 1000000. M
InputValue >= 1000 K
(otherwise) (blank)
Call this decision in data transform to get the suffix for your input.
In the datatransform use the below logic :
When suffix= M
Set .ConvertedValue = @String.format("%dM", .YourInputProperty / 1000000)
When suffix=k
Set .ConvertedValue = @String.format("%dK", .YourInputProperty / 1000)
Otherwise
.ConvertedValue = .YourInputProperty