
1. Re: Why my formula is not pulling any data?
Deepak Rai Jul 13, 2018 10:15 AM (in response to Helen Wang)1 of 1 people found this helpfulCheck for any Filters

2. Re: Why my formula is not pulling any data?
Anuvir Singh Jul 13, 2018 10:17 AM (in response to Helen Wang)1 of 1 people found this helpfulTry filtering with Fiscal Quarter with the 2019 Q1 date and see if you get any data. If not then the issue is with your Date field.

3. Re: Why my formula is not pulling any data?
Andy Piper Jul 13, 2018 10:27 AM (in response to Helen Wang)1 of 1 people found this helpfulHelen,
If the value returned by the formula is null, the ZN expression will report 0. If you break out the components of the formula into separate calculations, do any of the components show Null?
For example:
 DateTest: IF str(DATEPART('year',[Fiscal Quarter] ))= '2019' THEN [$ Ship Final ActFcst] END)
 QtrTest: IF str(DATEPART('quarter',[Fiscal Quarter] )) ='1' THEN [$ Ship Final ActFcst] END)
If that doesn't help determine where the problem might reside, know that it is hard to recreate something that works for you with some of your data but not all of it when those trying to help don't have access to any of your data. You may want to consider posting a sample workbook (with values changed to protect the innocent) that displays the problem.
Hope that helps,
Andy 
4. Re: Why my formula is not pulling any data?
Helen Wang Jul 13, 2018 10:40 AM (in response to Deepak Rai)Thank you so much ! It turns out that I didn't select.
I have an extra question: You have taught me before that: If I want to hide Q3 2018, then all the Q3 will be hidden ( Q3 2016, Q3 2017)
That is why I use this to code calculation that extract Q3 2018 for me specifically. Is this way to go if I want to present ?
Also, if I want to present Q3 2018 QoQ,
I cannot run Table Calculation on the data. and name it Sales Profit QoQ, then just extract Q3 2018 QoQ for that right? (I have tried that. but once i hide the table calculation then Q3 2018 QoQ is gone).
May I use the calcualtion as below:
sum(Sales Profit Q3 2018) / sum( Sales Profit Q2 2018) 1?
Thanks,
Helen

5. Re: Why my formula is not pulling any data?
Helen Wang Jul 13, 2018 10:41 AM (in response to Andy Piper)Thank you so much Andy! Such a great methodology.

6. Re: Why my formula is not pulling any data?
Helen Wang Jul 13, 2018 3:33 PM (in response to Deepak Rai)hi Deepak,
if you have a minute, could you please give me some advice on:
How to write calculation to extract newest rolling 6 weeks data from Tableau
Thanks,
Helen

7. Re: Why my formula is not pulling any data?
Helen Wang Jul 16, 2018 11:03 AM (in response to Deepak Rai)Hi Deepak,
If possible, could you please give me some advice @
How to put data from different data source into a fixed calculation?
Thanks,
Helen