I am trying to create a text box with a count of records which meet certain criteria, but I'm having problems getting the syntax to work. I have 2 tables in my load script (OrderA and OrderB) and within my app I have the below calculated dimension, which utilizes fields from both:
What I want to do is have a text box which counts the number of 'Yes' records - at the moment the above just provides a null ('-') in the text box, however I know that there should be a value of '1' shown
