
1. Re: Calculated Member formula to show or not show measure?
Sankarmagesh Rajan Sep 15, 2015 11:41 PM (in response to Greg Mooney)Hi Greg
in you calc added else with =
ELSE ([Measures].[Volume],[DIM Amount Type].[Amount Type Code].[Forecast])=NULL
Thanks
sankar

2. Re: Calculated Member formula to show or not show measure?
Greg Mooney Sep 16, 2015 7:50 AM (in response to Sankarmagesh Rajan)Sankar,
It looks like what you are suggesting is the same thing that I have?

3. Re: Calculated Member formula to show or not show measure?
Sankarmagesh Rajan Sep 16, 2015 10:25 PM (in response to Greg Mooney)hi remove the null from else and add 0.
ELSE 0 end
now you can get ans.

4. Re: Calculated Member formula to show or not show measure?
Tableau kumar Sep 17, 2015 12:05 AM (in response to Greg Mooney)We can't write = after 'then' in conditional Statements.
if [Region]="South" then [City]= "All" end ( This is not valid syntax in Tableau)
if you want to assign null when matched condition , simply leave don't define any thing.
If sum([Sales]) <0 then "Red"
elseif sum([Sales]) <250000 then "Blue"
end ( This is valid syntax in Tableau)
If Sales value equal to 26000 then takes null, since we did not define the values for >250000
If you want to see how write conditions in Tableau, go through the below link
http://visualizationwithtableausoftware.blogspot.in/2015/09/conditionalcalculations.html

5. Re: Calculated Member formula to show or not show measure?
Greg Mooney Sep 17, 2015 7:35 AM (in response to Sankarmagesh Rajan)This still gives me the same error

6. Re: Calculated Member formula to show or not show measure?
Greg Mooney Sep 17, 2015 7:36 AM (in response to Tableau kumar)My formula does not have = after Then
IF [Select target to compare Actual to:] = "Forecast"
OR [Select target to compare Actual to:] = "Both"
THEN ([Measures].[Volume],[DIM Amount Type].[Amount Type Code].[Forecast])
ELSE ([Measures].[Volume],[DIM Amount Type].[Amount Type Code].[Forecast])=NULL
END

7. Re: Calculated Member formula to show or not show measure?
Greg Mooney Sep 17, 2015 10:31 AM (in response to Greg Mooney)I resolved this via a calculated field.
Thanks