Issues making my calculated field work

Reply
Highlighted
White Belt

Issues making my calculated field work

case
when ((SUM(CASE when `Activity Date`>=CURDATE()-28 then `Score` end))/(SUM(CASE when `Activity Date`>=CURDATE()-180 then `Score` end))*100)>=50 and (SUM(CASE when `Activity Date`>=CURDATE()-180 then `Score` end))/ 307>=0.5 then COUNT(`Account`)end

 

what am i doing wrong to make this work. It is not coming up as an error but there is no number showing on my text card - it remains blank

Major Blue Belt

Re: Issues making my calculated field work

Null value in either `Activity Date` or `Score` could cause a blank result.  That would be the first place I would look.


-----------------
Chris
Green Belt

Re: Issues making my calculated field work

You do not have an else clause that I can see. What should the value be if the part after WHEN is not true?

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!