I would like to see the data - at least a protion - a few rows in a TWBX tableau file or even an exce with the dimensions included
If it were nulls you would not get a 0 you would get a blank (unless you preset your dfault to show 0 for nulls)
You can check by wrapping you individual data variables in a zn() function
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I see 2 potential issues:
- To get around null values, you can use ZN(Total License Revenue) (it transforms null values to 0).
- You might need to do sum(Total License Revenue) + sum(Total Cloud Revenue) + sum(Total Laas Revenue)
Thank you for the responses. Unfortunately I don't know how to use the ZN function but will play around with that. I'm not even sure how to send a portion of the twbx file and cannot send it all because of confidentiality purposes.
I already tried doing the SUM(Total License Reve) + Sum(Total Cloud, etc, but it didn't like that. It said you can't aggregate fields that are already aggregated.
1 of 1 people found this helpful
OK, then replace sum by zn, since the syntax is identical : ZN([field to hard code to 0 if value is null])
Can you make create a data set that is similar to your production set (same format etc), and use that rather than your production data? You can then replace your data set with this copy.
Here is how to create a packaged workbook.
Here is how to replace a data source.
Replace Data Sources
You can export portions of a workbook to a new one (say if you just wanted to share one table)
I usually make a fake spreadsheet in excel using a randomized subset of my data in Excel, create a new workbook from that, and try and replicate the issue there using the same formulas.
Sometimes just doing that, sheds some light on your problem.
Yay! Please mark which answer solved the problem so other people will know what to do.