calculate sumof sales

[ksk278074]

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?

[shwethaa]

Hi,

Use SUM(Field_Name) function.

Refer Help Page 

Refards,

Shwetha A

[ksk278074]

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 · Accepted solution]

In a crude way, you can try like:

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