Hi Folks,
I have Doubt, please let me know how can I resolve that.
Alteryx output without reporting tool | ||||||
DPM | Unit | 24-Apr | 24-May | 24-Jun | till Jan-25 | |
A | % | 1.567456 | 5.56756 | 3.5656 | 7.787 | |
B | Kcal | 454.56 | 565.656 | 233.564 | 895.5765 | |
C | % | 0.24566 | 0.33223 | 0.4644 | 0.43456 | |
D | Kwh | 55.24554 | 59.989 | 37.99977 | 25.56798 | |
E | % | 0.0123 | 0.02334 | 0.045565 | 0.05758 | |
Required result | ||||||
DPM | Unit | 24-Apr | 24-May | 24-Jun | till Jan-25 | |
A | % | 1.56 | 5.56 | 3.56 | 7.78 | Till 2 decimals |
B | Kcal | 454 | 565 | 233 | 895 | |
C | % | 24.70% | 33.50% | 46.90% | 43.70% | Till one decimal with % symbol |
D | KWH | 55.24 | 59.98 | 37.99 | 25.56 | Till 2 decimals |
E | % | 1.20% | 2.30% | 4.50% | 5.70% | Till one decimal with % symbol |
I want the Result required table in the reporting tool (Table tool) as well in the same format |
Please let me know how we can get the required result. with percent symbol in the report table. In report table all the results automatically convert to round numbers but i want the same result as the Alteryx result window's required formatting in the result such as adding the % symbol and get 1 or 2 decimal place values.
Thanks,
Kaustubh