Q. Can I total values in a table, e.g. one amount in a number field per row?
To cover a related question, this approach should work for check boxes in a table which gave been allocated values
Assuming you have a table with repeating rows in place
You then need to open the script editor panel via the Window menu.
Select the field that will act as the grand total – in my example, this is called Total.
In the Object panel set value to Calculated Read Only
Set Value to Calculated Read Only
In the Script Editor panel choose calculate
Set the Language to FormCalc
Then in the panel add the following code – Use your table name, row name and field name. Read [*] as saying “for each instance of the object” “This” refers to the currently selected object, in this case the grand total field.
A Ted talk to lighten your day: James Veitch: This is what happens when you reply to spam email. I usually recommend deeper technical or data oriented TED talks. This one is fun and good place to start with TED talks.
As people may know I am currently doing the Data Analysis course via Duke University and Coursera. While I am my data kick I am keeping track of news of new and updated tools. And so I have two bits of news:
Microsoft has released an update for Power BI desktop and also a universal app (to suit Windows tablets, phones and PCs). I will explore these tools further after I have complete the current module of the data analysis course.
Not all versions of Excel are created equal. For Excel 2013 and Excel 2016, many common versions of the the Office suite do not support PowerPivot. The linked article clearly outlines the situation for Excel 2016 (thank you to PowerPivotPro and Rob Collie).
In my view this is a pointless attempt at supporting the deluxe versions of the Office suite. It is going to cause confusion when preparing for Excel PowerPivot courses, and also for small business users who may have Office 365 Business Premium via an Office 365 subscription.
PowerPivot is not just for big corporate users. I can see small and medium businesses who want to be competitive and responsive in the current economic climate finding these tools essential. It is also going to be a key addition to the range of courses I offer!
Like me they will end up either buying a stand alone Excel licence or (in Australia) navigating the Telstra/Microsoft labyrinth to see if they can upgrade a of subscription or two to the required level. I will probably have to get standalone licences as there appears from exploring Telstra’s online interface that there is no option to upgrade further on my current Office 365 level. As a very small business I also don’t enjoy buying additional licences that duplicate something I already pay for.
A frustrating and expensive situation that will impact on the take up of a very useful tool.
Boagworld Podcast features Gerry McGovern in this weeks podcast. While its not about SharePoint – covering Intranet effectiveness, end user adoption and getting management buy in/support are very effectively addressed. People involved in SharePoint sites and roll-outs would benefit from listening to this. You will find Podcast and transcript here.
I picked up a couple of good ideas – include starting with solving a management problem e.g. streamlining an approval process to get manager buy in.