percentage problem (negative value)

[Holmes]

Hello,

I am trying to calculate the percentage of occurence in a report.

I am using the following code in the data source for the text box:

=(Sum([Text6]="Boblat")/([Text12]/100))


When I run the report the percentage is correct it is just a negative figure.
how can I correct this problem?

Many thanks in advance, (it's probably something simple that I'm missing!)

 

[Rich]

Use the Abs function

 

[Holmes]

abs gives something totally different.

Sum was close, but just negative any ideas?

 

[Dennisk]

I think he ment the ABS of the SUM, and not replace SUM with ABS.

Hint : replace [Text6] and [Text12] with a more meaningful description.

 

[Holmes]

Thanks for that. I have preceded the statement with abs(Sum[tex.....)
it's working fine now.

I have changed the text box names.

Again many thanks.