• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 749
  • Last Modified:

Sum nvarchar field

HI:

I have a field which is nvarchar in my crystal report. I want the sum of that field for each group. How do i do that. I can only perform maximum,count and other functions on that field but not sum....:-( Help is appreciated.

Thanks Ashwin
0
Ashwin_shastry
Asked:
Ashwin_shastry
1 Solution
 
frodomanCommented:
Create a formula to convert the text to a number - something like:

cint({table.nvarchar_field})


Now create your sum on the formula instead of on the field itself.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now