This content has been marked as final.
Show 11 replies
-
1. Re: LOD without aggregation
Zhouyi ZhangSep 11, 2019 8:55 PM (in response to Josephine de Guzman)
Hi, Josephine
Do you have a sample workbook to share?
ZZ
-
2. Re: LOD without aggregation
Abdul Munaf Sep 11, 2019 9:08 PM (in response to Josephine de Guzman)Hi Josephine
Please share a sample workbook
Regards
Munaf
-
3. Re: LOD without aggregation
Josephine de Guzman Sep 11, 2019 9:58 PM (in response to Josephine de Guzman)Attached a sample workbook. Thank you!
-
FTM Tableau Comm.twbx 6.2 MB
-
-
4. Re: LOD without aggregation
Manoj Lobo Sep 11, 2019 10:11 PM (in response to Josephine de Guzman) -
5. Re: LOD without aggregation
Josephine de Guzman Sep 11, 2019 10:57 PM (in response to Manoj Lobo) -
6. Re: LOD without aggregation
Manoj Lobo Sep 11, 2019 11:07 PM (in response to Josephine de Guzman)Hi,
The above formula should work for both the cases.
if the field contains null or a 0 then it returns fail else pass.
Manoj
-
7. Re: LOD without aggregation
Josephine de Guzman Sep 11, 2019 11:25 PM (in response to Manoj Lobo)1 of 1 people found this helpfulI tried the formula but it didn't work. I am unable to share the workbook since its connected to HANA.
-
8. Re: LOD without aggregation
Zhouyi ZhangSep 11, 2019 11:38 PM (in response to Josephine de Guzman)
-
9. Re: LOD without aggregation
Manoj Lobo Sep 11, 2019 11:41 PM (in response to Josephine de Guzman)Not sure what the problem is, unless the several filters you're using isn't filtering out the 0's you should get the expected result.
I haven't worked with HANA but can you create an extract and then save the workbook if possible?
Manoj
-
10. Re: LOD without aggregation
Josephine de Guzman Sep 12, 2019 12:00 AM (in response to Zhouyi Zhang) -
11. Re: LOD without aggregation
Josephine de Guzman Sep 12, 2019 12:00 AM (in response to Manoj Lobo)I actually did it and it worked fine so I'm guessing the problem is with the data source.