Formula Problem

building reports desktopintelligence
1

Hi Susan,

Just put your last sum into brackets.
I’ve tried following formula (BO 5.0.1), it works.

=Sum( Where (=“A”))-(Sum( Where (=“B”)))/0.123456

Ilya

Listserv Archives (BOB member since 2002-06-25)

2

I have the following formula in my report (and it works correctly):

=Sum( Where (=“A”))-Sum( Where (=“B”)/3)

I want to change the 3 at the end of the formula to be some fraction of 1. Therefore the number would have to be a decimal. When I change the number to a decimal, I get a Syntax error.

Please help!!

Thanks
Susan Fowler
ISM Fastening Systems

Listserv Archives (BOB member since 2002-06-25)

3

Hi Susan,
Did you try it this way
=Sum( Where (=“A”))- Sum(( /0.13) Where (=“B”))

Hamid

Listserv Archives (BOB member since 2002-06-25)

4

Just tried, and still get the syntax error. Any other suggestions? Susan

Listserv Archives (BOB member since 2002-06-25)

5

What are you trying to put in? E.g.: ,3 or .3 or 0,3 or 0.3 It also seems that there is one bracket missing at the end of your formula.

Susan Fowler wrote:
=Sum( Where (=“A”))-Sum( Where (=“B”)/3)
I want to change the 3 at the end of the formula to be some fraction of 1.Therefore the number would have to be a decimal. When I change the number to a decimal, I get a Syntax error.

Listserv Archives (BOB member since 2002-06-25)

6

I am trying to put in .3.
Susan

What are you trying to put in? E.g.: ,3 or .3 or 0,3 or 0.3 It also seems that there is one bracket missing at the end of your formula.

Susan Fowler wrote:
=Sum( Where (=“A”))-Sum( Where (=“B”)/3)
I want to change the 3 at the end of the formula to be some fraction of 1.Therefore the number would have to be a decimal. When I change the number to a decimal, I get a Syntax error.

Listserv Archives (BOB member since 2002-06-25)

7

Susanm

How about trying Where (=“B”)/(1/3)? The 1/3 gives you the .3 you’re looking for in the formula.

Irene Walsh
QuadraMed Corporation

************************************************************** I am trying to put in .3.
Susan

What are you trying to put in? E.g.: ,3 or .3 or 0,3 or 0.3 It also seems that there is one bracket missing at the end of your formula.

Susan Fowler wrote:
=Sum( Where (=“A”))-Sum( Where (=“B”)/3)
I want to change the 3 at the end of the formula to be some fraction of 1.Therefore the number would have to be a decimal. When I change the number to a
decimal, I get a Syntax error.

Listserv Archives (BOB member since 2002-06-25)

8

Susan,

Try using the format 0.3

I believe it is choking because the first value it sees is not a numeric value (rather the decimal itself). The 0.3 should resolve that particular issue.

-RM

From: Susan Fowler SFowler@CCIA.COM
I am trying to put in .3.
Susan

From: Eric Kok [SMTP:Eric.Kok@KNOWARE.NL]

What are you trying to put in? E.g.: ,3 or .3 or 0,3 or 0.3 It also seems that there is one bracket missing at the end of your formula.

Listserv Archives (BOB member since 2002-06-25)

9

We are migrating from BO 4.1.3 to BO 5.0. We have similar formulas in the 4.1.3 reports utilizing “Where”. When opened in 5.0 - the formulas with “Where” give incorrect solutions. Anyone else seen this?

=Sum( Where (=“A”))-(Sum( Where (=“B”)))/0.123456

Ilya

Listserv Archives (BOB member since 2002-06-25)

10

In a message dated 00-01-31 18:18:58 EST, you write:

I am trying to put in .3.
Susan

You have to use the leading zero. Use 0.3 instead of .3 and your problems should be solved!

I like the easy ones…

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)