Count values of calculation results

[siobhancrossen]

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

[sunny_talwar]

May be this

=Sum(

if((OrderATime-OrderBTime) > 0, 0,

if((OrderACancelTime-OrderBTime) < 0, 0,

if((OrderACancelTime-OrderBCompletionTime) < 0, 0, 1)))

)