Count the number of days a field has a value less than 200

General
Highlighted

Count the number of days a field has a value less than 200

Hi guys,

I'm relativley new to this so please bare with me.  I'm trying to count the number of days a filed has a value under 200. Between two dates.  i.e.

For accounts in the last 180 days,

count how many days the balance was < 200

and display sum of this count against each of the dates.

Any help would be appreciated!

Thanks 

j

1 REPLY
Teradata Employee

Re: Count the number of days a field has a value less than 200

Looks like some homework to me ;)

Have you already tried something, if so please post here.