Forum Discussion
Helper IIDon't include blanks in COUNTROWS
Hello,
Couple notes. If you're using the filter function for the same table, then you can use && or || for multiple conditions.
Why don't you also say in your condition that complete date can't equal blank (just to test if that works)?
Also, I usually make an additional column for my week offset columns which is of a string type and I have a formula in there which says to rename the 0 to "Current Week". I do this because in the line charts or column charts it comes through quite nicely. Also, for all of the other prior weeks I call it Week -X.
Resolver IVHello,
Couple notes. If you're using the filter function for the same table, then you can use && or || for multiple conditions.
Why don't you also say in your condition that complete date can't equal blank (just to test if that works)?
Also, I usually make an additional column for my week offset columns which is of a string type and I have a formula in there which says to rename the 0 to "Current Week". I do this because in the line charts or column charts it comes through quite nicely. Also, for all of the other prior weeks I call it Week -X.
Helper IIThanks...I tried added not isblank for datecomplete and it gives me the whole recordset. I will try your second suggestion.