Forum Discussion
Math.Abs(dAmount_1), Math.Abs(dAmount_2), etc should give you what you need.
Hi Jon,
Yes, it did. Is there a way though to recall the original value from it?
Ex. If -1,000,000 was the largest value, currently the UD8 gives me a result of 1M. Is there a way to make it recall it back to the original -1M instead?
Will
I'm not sure why you would need to do that. You have the original amount from the dAmount_1 variable and then you can set the absolute value to a new variable.
Basically our tax team needs to pull the largest absolute value but from each interco that entity is assigned to, but then sums those largest values up together based off of tax type which I've created as a text6 field.
Ok I think I understand. Perhaps instead of using an array, you can put the values in a dictionary with the Name being the decimal name and the Value being the absolute value. Then you can pull the max value along with the name and then use the name to look up the original variable.
Related Content
- 12 months ago
- 5 months ago
- 11 months ago
- 7 months ago