Newbie Questions

Re: Basic Formula help

abiigdog — Fri, 15 Oct 2010 22:19:08 GMT

Yes your right that's what it's doing. I guess I need to do a count operation when the value is greater then zero, and further down the rabbit hole I go.

Re: Basic Formula help

Jimmy — Fri, 15 Oct 2010 06:38:02 GMT

Are you still dividing by 12 when you use the values 2 and 4? If so, 1 is the expected result:

(2 + 4) / 12 -> 0.5 (round)-> 1

Re: Basic Formula help

abiigdog — Fri, 15 Oct 2010 05:52:32 GMT

Nevermind tried it just turns the div to the symbol anyways. It displays a number but not a correct one. using two values of 2 and 4 it tells me the average is 1 instead of 3, still stumped.

Re: Basic Formula help

abiigdog — Fri, 15 Oct 2010 05:47:56 GMT

I tried that but I think I have the syntax wrong or it doesn't work. Tried Round(Sumsection / 12) do I need to use the "div" instead of the divide symbol?

Re: Basic Formula help

Jimmy — Fri, 15 Oct 2010 05:03:55 GMT

What if you round the average?

round(sumsection div 12)

Re: Basic Formula help

abiigdog — Fri, 15 Oct 2010 04:44:35 GMT

Well I could but then I wouldn't have the average, need it to average then round in the same expression.

Re: Basic Formula help

Jimmy — Fri, 15 Oct 2010 04:24:04 GMT

How about using the round() function? :-)

Basic Formula help

abiigdog — Fri, 15 Oct 2010 03:52:05 GMT

I have several fields summed and sent to a field called SumSection. I have a AverageScore field that is a text box that I want to average the result of the SumSection field. I can do the average fine by using (Sumsection) / 12, twelve being the number of fields. But how do I round the result? I just can't figure out how to string together then average formula and have it round before displaying the input. Want it to round to the nearest whole number, no fractions.

Anyone able to tell me what exactly I would type into the Fx box?