counting # of true and false values in a formula 1

[eoggb]

I have CR 10 and I am doing a query of number of true and false vales that are produced off of my original formaula.

original formula:

if mid({Product.Primary SKU/PLU/UPC},1,5) like "-?*" then true

this gives me a list of true and false values for which I though I could do a count on, but it counts all true and false.

So my question is how can I seperate the true and false vales produced by the original formula and do a count on each. Any ideas? Thanks in advance

 

[MisterMo]

You could use two running totals to count your formula field and on the evaluate section choose the X-2 button
and add something like

{@YourFormula}= true // for the first

{@YourFormula}= False // for the Second

then you can reset at the end of a group or report




-Mo

 

[lbass]

If you change your original formula to:

if mid({Product.Primary SKU/PLU/UPC},1,5) like "-?*" then 1

...you can write click on in and insert a summary (SUM, not count).

-LB