Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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:
=if((OrderATime-OrderBTime) > 0, 'No',
if((OrderACancelTime-OrderBTime) < 0, 'No',
if((OrderACancelTime-OrderBCompletionTime) < 0, 'No', 'Yes')))
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
Any help would be hugely appreciated!
Many thanks
Look here