I have a simple sample List. I’m stuck on how to get the Prices field to allow a calculation. By default the Calculations Row only allows ‘Count:’ as a chooseable field option. How can I have it so the Prices field can show a Total amount – or I suppose Average or some other calculation? see screenshot
Attachments:
You must be
logged in to view attached files.
If I were to guess, I think your Amount field is set to return a Text value instead of a Number value. When it returns a Number value, then you have access to the Total, Min, Max, and Avg calculation options under that popup button.
Brendan,
Yeah, I figured that one out about 5 minutes after posting the question! I had downloaded before a flight today, hit this simple user error based issue, posted, then hopped on the flight. I have now figured out pretty much everything I need except a searching issue, but I’ll post that as a separate question. Once that is resolved, I’m set – really liking this so far.
Thanks
Davo