Sum data in report (1 Viewer)

L

luzz

Registered User.

Local time

Yesterday, 16:11

Joined

Aug 23, 2017

Messages

346

• Apr 16, 2018

• #1

Hi all, I would like to sum up multiple fields in a textbox in my report. I tried summing up by using expression builder, however the result display on my report seems to concatenate the number together instead of summing it.

 

Attachments

• 
  Untitled.png

  5.6 KB · Views: 43
• 
  expression builder.png

  46.6 KB · Views: 39

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 16:11

Joined

Aug 30, 2003

Messages

36,124

• Apr 16, 2018

• #2

Your data is being seen as text. You can fix it at the source or wrap each field in the appropriate conversion function (CLng, CCur, etc).

 

L

luzz

Registered User.

Local time

Yesterday, 16:11

Joined

Aug 23, 2017

Messages

346

• Apr 17, 2018

• #3

pbaldy said:

Your data is being seen as text. You can fix it at the source or wrap each field in the appropriate conversion function (CLng, CCur, etc).

Click to expand...

I have managed to sum the number up, however i am only able to sum up the textbox that display number and once i use expression builder to sum up textbox that display number and textbox that does not display number, it will return a blank textbox. How can i sum up the textbox without number as well?

 

Attachments

• 
  Untitled.png

  1.9 KB · Views: 37

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 16:11

Joined

Aug 30, 2003

Messages

36,124

• Apr 17, 2018

• #4

You may also need the Nz() function.

 

L

luzz

Registered User.

Local time

Yesterday, 16:11

Joined

Aug 23, 2017

Messages

346

• Apr 17, 2018

• #5

pbaldy said:

You may also need the Nz() function.

Click to expand...

Okay, it works! Thank you

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 16:11

Joined

Aug 30, 2003

Messages

36,124

• Apr 17, 2018

• #6

Happy to help!