Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Sum issue Post Reply Post New Topic
Author Message
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Topic: Sum issue
     Posted: 30 Sep 2013 at 10:33pm

Hi!

I got a purchase list report and i want to insert a total sum of all the purchases in the RF.
 
I tried doing a Running total but it came up blank and with a sum formula it comes up ######.
 
I got a formula (rowsum) - number of items * unit price, looking like this:
{PURCHASE_ITEMS.ANTAL}*{PURCHASE_ITEMS.PURCHASEPRICE}
 
And then i got a formula (Totalsum) looking like this:
Sum ({@rowsum})
 
I know it should be easy but i cant get it right Embarrassed


Edited by Wosp - 01 Oct 2013 at 3:59am
IP IP Logged
Gurbs
Senior Member
Senior Member
Avatar

Joined: 16 Feb 2012
Location: Ireland
Online Status: Offline
Posts: 216
Quote Gurbs Replybullet Posted: 01 Oct 2013 at 4:03am
make the output field a little bit bigger. When it shows up as ##### is means that there is not enough space to show the entire value.
IP IP Logged
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Posted: 02 Oct 2013 at 11:33pm
Originally posted by Gurbs

make the output field a little bit bigger. When it shows up as ##### is means that there is not enough space to show the entire value.
 
No doesn't work, dont even get the ##### anymore. Just a blank field?
The report works as it should otherwise.
Is there any other formula that i could use, i have the formulas shown above and i used the Sum ({@rowsum}) in a running total, but still comes out blank...
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Oct 2013 at 2:57am
if you have nulls then you will need to make sure that the rowsum formula is set to 'use default values for nulls'
IP IP Logged
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Posted: 03 Oct 2013 at 7:15pm
Originally posted by DBlank

if you have nulls then you will need to make sure that the rowsum formula is set to 'use default values for nulls'
 
Problem solved, my bad-there where 2 tables with similar names and i of course used the wrong one in the formula Embarrassed
 
Thank you for your effort anyway, now im gonna go and spank myself Tongue


Edited by Wosp - 03 Oct 2013 at 7:37pm
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.