Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
All values seems to be unrelated to your application.
Maybe there´s a filter that is beeing applyied
You data is formatted as Text, try
SUM(TRIM(Salesvalue))
Hi, If i make selections in listbox it shows the sum value.
Hi, I tried but no changes. Thank you.
Some selections are filtering out your values
Hi Viresh,
Try:
=Sum(alt(SalesValue,0))
Cheers
Andrew