we have several True/False Booleans in AF (Fans on or off) and want to roll them up to count how many are on - but AF always give us the answer or zero no matter how many are on ???
You need to convert that digital string to an integer.
See if this helps: Re: PI AF Formula Syntax
Thanks Karl - we suspected this might be the answer - just frustrating that the Boolean is probably stored as a 1 or 0 in the system so why can't it deal with this???
How it's stored is not that relevant. It's still a boolean, and two trues are not more true than one true. That's why it's a bool!. If you want to count occurrences, you need to do that, or convert a true into a '1' and a false into 0 and sum the values.
But how do we count occurances? Count seems ok with numbers but not with anything else???
Let's first clarify "RollUp". In one meaning it can be the combination of a number of other numbers, e.g. using the Formula Data Refernce, or an Expression analysis. A second meaning could be the use of the RollUp analysis, where attributes from child elements are aggregated to a higher level.
To answer for both cases (assuming all of these are values at a specific time, not doing any aggreations along the time axis):
The count rollup counts events, so that won't work.
Retrieving data ...