Division Error

(imported topic written by brock9191)

I’m running into a bit of an issue when trying to get a percentage into my table. The part that is giving me trouble is bolded. The strSites is an additional bit that specifies only certain sites to include.

prodarea.innerHTML = "

Patches Less Than 30 Days Old

" + EvaluateRelevance(‘concatenation of (trs of ((td of item 0 of it & td of item 2 of it & td of item 3 of it & td of item 1 of it & td of item 4 of it) of (link of it, applicable computer counts of it as string, source release date of it as string, (unique values of (current date - source release date of it)) as string, (number of results of it / applicable computer counts of it) as string)))of (bes fixlets whose (((current date - 30*day) < source release date of it) and (applicable computer count of it > 0) and (false’ + strSites + ‘)))’) + “
Fixlet Source Release Days Old Applicable Percent
”;

Most issues I run in to can be fixed by finishing it up as a string, but I can’t get it to work in this instance. Any help would be greatly appreciated.

(imported comment written by BenKus)

Make sure to remove the “s” on" counts"… See if this works:

… (number of results whose (not relevant flag of it) of it * 100/ applicable computer count of it) as string)) …

Ben

(imported comment written by jessewk)

You need to make ‘applicable computer counts’ singular.

I also needed additional error checking to make sure that a fixlet had results, a link, a source release date, etc. That might because I have a lot of non-production content in my deployment though.

(imported comment written by brock9191)

Thanks. Worked like a charm.