This content has been marked as final.
Show 3 replies

1. Re: How to count consecutive blanks in a row
Don Wise May 7, 2018 2:26 PM (in response to Ashan Bogollagama)1 of 1 people found this helpful 
2. Re: How to count consecutive blanks in a row
Deepak Rai May 7, 2018 2:49 PM (in response to Ashan Bogollagama)Pl check the screenshot and attached.
If it Helps, Pl mark it Helpful and CORRECT to close Thread.
Thanks
Deepak

Count Zeros or Blanks.twbx 1.2 MB


3. Re: How to count consecutive blanks in a row
Ashan Bogollagama May 8, 2018 9:40 AM (in response to Don Wise)Hi Don,
This helped a lot, Thanks !
I modified it slightly to see if there is a "once every 3 years" trend in a 6 year period
IF ISNULL([SUM 2013]) AND ([SUM 2014])=1 AND ISNULL([SUM 2015]) AND ISNULL([SUM 2016]) AND ([SUM 2017])=1 THEN "True"
ELSEIF ISNULL([SUM 2013]) AND ISNULL([SUM 2014]) AND ([SUM 2015])=1 AND ISNULL([SUM 2016]) AND ISNULL([SUM 2017]) THEN "True"
ELSEIF ([SUM 2013])=1 AND ISNULL([SUM 2014]) AND ISNULL([SUM 2015]) AND ([SUM 2016])=1 AND ISNULL(2017) THEN "True"
END