Count number of days =SUM(History[Evaluation...

Count number of days

=SUM(History[Evaluation])/NUMBER(DATE(TODAY())-DATE(“1/7/2019”))

SUM(History[Evaluation])=141 NUMBER(DATE(TODAY())-DATE(“1/7/2019”))=0 I want to get ‘29’ as counting the days from 1/7/2019 but it keeps giving me ‘0’

How can I get ‘29’?

0 2 406
2 REPLIES 2
Top Labels in this Space