1 of 1 people found this helpful
I don't know what all your field names look like but maybe something like this:
IF SUM([Hotel Results])=0 THEN COUNTD([Search ID]) END
Let me know if something like this works. If not, upload a package workbook and I can see if I can help.
Thanks for coming back to me.
I have tried this and it works perfectly.
Many thanks - Mark
No problem, glad to help
If possible please share the sample dummy data, to get exactly what you want.
You can show us what exactly you want in separate sheet of excel as you know what is input and what output is expected out of it. If you do this, chances of getting solution early will increase.
Use this feature to upload the files. Please refer to the below screenshot.