Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Count and Countrows returning 'Blank' Value

I have a table with over 200,000 phone calls; but when I use 'Count' or 'Countrows' the value returned is blank.    What could be the underlying issue?   My measure is:   Total Calls = COUNTROW...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I have stopped creating date tables, and now create additinal columns within the table separating the month, day and year from the date column. After, I create attach an excel spreadsheet with distinct date values. This seems to be easier with lots of tables with multiple dates and years.

 

The problem was in the indexing table, I made the relationship inactive, and it is now working. I will have to see what the issue is with the relationship. 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I just lost $20!?  :)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymouscan I claim that you owe me $20 since inactive relationship was #1 on my list? :smileyvery-happy:

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      AnonymousAnonymous 

       

      The indexing column was actually last lol! 

       

      There was never a date table.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Yeah but I did say inactive relationship in #1. Shhh, back me up on this. I'll split the $20 with you!