Adding column totals

I have an app where I would like to record sales which I have already done.
I would also like to have a record of year to date totals from each vendor.
My record totals sales for each transaction. When I try to add the figures for a YTD total it doesnโ€™t work.
I have a View where in the App Formula I put SUM(Sales[Total])
When I click Test it shows the total of the figures in the column Total
But, it does not show me a total in my App or put the figure in my Google Doc form.
The column type of each is price if that matters though I have changed both types to number and it still does not work.

0 10 1,256
10 REPLIES 10
Top Labels in this Space