Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ksk278074
Contributor III
Contributor III

calculate sumof sales

HI team,

I am having table like below .. i ant to calculate sum of sales

Product, sales

A,20

b,30k

c,40k

how to calculate sum of sales?

 

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

In a crude way, you can try like:

=Sum(Replace(sales, 'k','000'))

Capture.PNG

 

View solution in original post

3 Replies
shwethaa
Contributor III
Contributor III

Hi,

Use SUM(Field_Name) function.

Refer Help Page 

Refards,

Shwetha A

ksk278074
Contributor III
Contributor III
Author

thanks for the reply

 

but i am having "K" value for some filelds in that i want to multiply the value* 1000 .

 

How can we get that ?

 

 

tresesco
MVP
MVP

In a crude way, you can try like:

=Sum(Replace(sales, 'k','000'))

Capture.PNG