Value not showing

[vireshkolagimat]

Hi All,

I have field called SalesValue and it has data. But when i try to do sum like Sum(SalesValue) it is showing as 0(zero) even thought i have data for the SalesValue column.

Any idea what is the issue. Attached is the screenshot for your reference.

Regards,

Viresh

h

[Clever_Anjos]

All values seems to be unrelated to your application.

Maybe there´s a filter that is beeing applyied

[vinieme12]

You data is formatted as Text, try

SUM(TRIM(Salesvalue))

[vireshkolagimat]

Hi, If i make selections in listbox it shows the sum value.

[vireshkolagimat]

Hi, I tried but no changes. Thank you.

[Clever_Anjos]

Some selections are filtering out your values

[effinty2112]

Hi Viresh,

Try:

=Sum(alt(SalesValue,0))

Cheers

Andrew