I have a formula which identifies if a document is pass or fail.
So what's happening is when this is shown on a high level the result is aggregated which makes everything "Pass" when its should't be.
Sep 11, 2019 8:55 PM
Hi, Josephine
Do you have a sample workbook to share?
ZZ
Hi Josephine,
I had a look at your workbook and the mentioned field didn't have any 0 values, instead they had nulls
so I modified the formula and obtained the following result.
Hope this helps!
If this reply helps, mark it as helpful/correct
Manoj
Hi Manooj,
Thank you for this. Is there a different formula just in case the field contains zero?
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
I tried the formula but it didn't work. I am unable to share the workbook since its connected to HANA.
Sep 11, 2019 11:38 PM
Hi, Josephine
With Manoj's calculation, can you check whether your stack marks is turned on?
ZZ
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
I actually did it and it worked fine so I'm guessing the problem is with the data source.
