rohithbli

New Member
Joined
Jun 21, 2018
Messages
2
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"

captionnameformula
Year_Brand[Calculation_385057835130777604]if [Parameters].[Parameter 2] = "This year" then [Calculation_385057835129393153]



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



else [Calculation_385057835129860099]



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




[Data Shown Filter (copy)]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

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,109,476
Messages
5,529,070
Members
409,849
Latest member
J7House1984
Top