Hi,
I am using this formula & am getting an error:
=CALCULATE([Time_Between_Update],Sheet1[Scope]=1)
The error is: Column 'Time_Between_Update' cannot be found or may not be used in this expression.
Can someone help me with this.
Regards,
Sid.
Hi,
I am using this formula & am getting an error:
=CALCULATE([Time_Between_Update],Sheet1[Scope]=1)
The error is: Column 'Time_Between_Update' cannot be found or may not be used in this expression.
Can someone help me with this.
Regards,
Sid.
Hello,
you are referring to Sheet1 in the formula. Is there a relationship to Sheet1? Calculate only works with properly configured relationships between tables, and you may also need to use the Filter() function to narrow down the relevant results.
Hi teylyn,
There is only one sheet and the formula is being written in a column in the same sheet where the two columns are present.
It's not clear what the problem is. Post a sample file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks