Request macro

[rohithbli]

The column "name" must match with column "formula"


ex :the Value "Calculation_385057835130777604" must match in column "Formula" and must replace with column "Caption" value

"Calculation_385057835130777604" must change to "Year_Brand"

[TABLE="width: 1091"]
<tbody>[TR]
[TD]caption[/TD]
[TD][/TD]
[TD]name[/TD]
[TD]formula[/TD]
[/TR]
[TR]
[TD]Year_Brand[/TD]
[TD][/TD]
[TD][Calculation_385057835130777604][/TD]
[TD]if [Parameters].[Parameter 2] = "This year" then [Calculation_385057835129393153]



elseif [Parameters].[Parameter 2] = "Current Month" then [Calculation_385057835129593858]



else [Calculation_385057835129860099]



END[/TD]
[/TR]
[TR]
[TD]Previous Year_[/TD]
[TD][/TD]
[TD][Calculation_385057835142270982][/TD]
[TD][Parameters].[Parameter 1]-1[/TD]
[/TR]
[TR]
[TD]ΔPY YTD_Brand[/TD]
[TD][/TD]
[TD][Calculation_385057835145179143][/TD]
[TD]SUM([Calculation_385057835130777604])-SUM([Data Shown Filter (copy)])[/TD]
[/TR]
[TR]
[TD]EU_YTD[/TD]
[TD][/TD]
[TD][Calculation_385057835146694665][/TD]
[TD]{ FIXED [Month],[SEGMENT] : SUM([Calculation_385057835130777604])}[/TD]
[/TR]
[TR]
[TD]Current Month_prev[/TD]
[TD][/TD]
[TD][Current Month (copy)][/TD]
[TD]if year([Month]) = year([Calculation_385057835142270982]) and month([Month]) = month([Parameters].[Year (copy)]) then [Zulassungen] end[/TD]
[/TR]
[TR]
[TD]Previous_Year_Brand




[/TD]
[TD][/TD]
[TD][Data Shown Filter (copy)][/TD]
[TD]if [Parameters].[Parameter 2] = "This year" then [This year (copy)]



elseif [Parameters].[Parameter 2] = "Current Month" then [Current Month (copy)]



else [YTD (copy)]



END


Thanks in advance


Regards
Rohit[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]