Forum Discussion
BlancaAnderson
7 years agoQrew Assistant Captain
I want to use formula numeric field. I tried this:
BlancaAnderson
7 years agoQrew Assistant Captain
Screenshot #1
Is the [Tub Count] Formula Field, it is a Formula Numeric Field - you can see the current formula I am using
Screenshot #2
This is what the Tub Count is summarizing/counting. If user selects NONE then I need 0, any others are selected then I need a count.
Screenshot #3
The report, the last two columns on the right, Tubs Needed and Tub Count. The NONE argument returns a 0, YAY! This works just as I want, the second argument should COUNT every letter, instead I get a number 3 no matter how many letters are selected.
Please help.
Is the [Tub Count] Formula Field, it is a Formula Numeric Field - you can see the current formula I am using
Screenshot #2
This is what the Tub Count is summarizing/counting. If user selects NONE then I need 0, any others are selected then I need a count.
Screenshot #3
The report, the last two columns on the right, Tubs Needed and Tub Count. The NONE argument returns a 0, YAY! This works just as I want, the second argument should COUNT every letter, instead I get a number 3 no matter how many letters are selected.
Please help.