This content has been marked as final.
Show 6 replies
-
-
2. Re: Data showing as null on graph
Michael Gillespie Nov 27, 2018 12:30 PM (in response to Jigon Kang)Your "Retail Price" calculation is looking for "Price Category" to be "Retail Price". if it is set to anything else on any of your vizzes, then the calculation will return NULL.
You do not have the Retail Price field on any of your worksheets but I assume that if you replace the "Price" field with "Retail Price" that is what you are looking for.
If you do that, but do not change the Price Category filter to "Retail Price" TOO, then you'll get NULLs.
-
3. Re: Data showing as null on graph
Jigon Kang Nov 27, 2018 12:34 PM (in response to Jim Dehner)Jim, I am talking about the Cost/Retail tab.
I think you are on the wrong tab.
-
4. Re: Data showing as null on graph
Jigon Kang Nov 27, 2018 12:35 PM (in response to Michael Gillespie)Michael,
I did the same formula for "Cost" and "Sell Price" measures. But they show the data.
How come they show up and "Retail Price" don't show up? -
5. Re: Data showing as null on graph
Michael Gillespie Nov 27, 2018 12:38 PM (in response to Jigon Kang)Because the Price Category filter is set correctly on those tabs.
-