Total Taxable Revenue FY2021
0
0
0
0
0
0
0
0
0
0
0
0
117488.33
0
0
0
39861.96
0
0
119908.39
0
0
0
15286159.59
16606081.42
22154163.66
0
6450665.81
264479.45
721013.31
1162765.83
6838902.09
3753534.14
411256.42
0
17245359.91
65648618.7
0
17369176.33
249055.41
2133031.64
0
7542635.24
4575040.78
0
518435.43
54695.64
5912118.31
0
0
0
0
0
0
0
0
-0.28
0
15207191.76
11113233.2
2228507.59
10672225.95
3332217.79
22578997.78
1611194.22
22354929.14
3484971.47
4385517.05
0
13175199.24
0
0
713224.12
0
0
0
0
0
82373.63
0
0
269050.2
0
0
Header Input
Header Input
Total Taxable Revenue FY2021
4115725.42
4115725.42
96041745.23
4115725.42
4115725.42
20569652.21
96041745.23
20569652.21
20569652.21
96041745.23
4115725.42
96041745.23
546476.32
20569652.21
546476.32
96041745.23
4115725.42
0.00
3492912.72
96041745.23
149616403.59
96041745.23
20569652.21
20569652.21
2563862.29
-2017385.97
-42004.88
4115725.42
0.00
3492912.72
19654.70
96041745.23
149616403.59
4115725.42
96041745.23
20569652.21
546476.32
-42004.88
4115725.42
3492912.72
96041745.23
4115725.42
20569652.21
546476.32
-42004.88
96041745.23
20569652.21
546476.32
4115725.42
20569652.21
20569652.21
4115725.42
96041745.23
0.00
4115725.42
96041745.23
149616403.59
4115725.42
20569652.21
546476.32
3492912.72
96041745.23
149616403.59
20569652.21
-224452.12
546476.32
-42004.88
4115725.42
3492912.72
96041745.23
0.00
96041745.23
96041745.23
4115725.42
96041745.23
20569652.21
4115725.42
4115725.42
96041745.23
96041745.23
0.00
149616403.59
0.00
96041745.23
Desired Required Headers
Desired Required Headers
Formula
IIF(EndsWith([_CurrentField_], '_2'),Replace(REGEX_Replace([_CurrentField_], '(.*)(_.*)', '$1'),'_','-')+'_2',Replace([_CurrentField_],'_','-'))
Horizontal
headers Transform