将计算的“报表”列添加到报表中
我们需要对报告中的汇总数据做一些计算。例如，将两个或多个列值相加，或将两个列的值相除以从中获得百分比值。计算不仅要在数据行中起作用，还要在报表的摘要行中起作用。
我的建议是制作一个计算列，类似于pivot计算区域，在pivot报告中的excel表格中启用。
我认为，这将提高报告的效率，并为用户提供更大的灵活性。ob欧宝娱乐app手机下载
标签:
类别
2023-05-09T02:45:49.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106138,"type":"idea","name":"Add Attachments to Alerts in general (not the ones on the row)","excerpt":"Please allow the addition of attachments that are not associated with a row. For example, when an alert is triggered, an email is sent and I would be able to attach an instruction sheet or welcome letter to the alert. Right now the options for doing this are either too limiting, cumbersome, or confusing for those who are…","categoryID":349,"dateInserted":"2023-06-07T15:09:08+00:00","dateUpdated":"2023-06-07T15:12:39+00:00","dateLastComment":"2023-06-08T18:41:51+00:00","insertUserID":161995,"insertUser":{"userID":161995,"name":"phillipo","title":"HR Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/phillipo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T18:42:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":103241,"lastUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T20:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":3,"hot":3372402959,"url":"https:\/\/community.smartsheet.com\/discussion\/106138\/add-attachments-to-alerts-in-general-not-the-ones-on-the-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106138\/add-attachments-to-alerts-in-general-not-the-ones-on-the-row","format":"Rich","tagIDs":[268,363],"lastPost":{"discussionID":106138,"commentID":379688,"name":"Re: Add Attachments to Alerts in general (not the ones on the row)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379688#Comment_379688","dateInserted":"2023-06-08T18:41:51+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T20:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106001,"type":"idea","name":"automation workflow approval - Use form to request additional information prior to Approve\/Deny","excerpt":"I am looking for the ability for the approver to ask a questions (normally from the requester) prior to making a final selection of Approve\/Deny. Currently the approval form has access to the comment field but the only way for the form to process something added to the comment field is if you select Approve or Deny (Which…","categoryID":349,"dateInserted":"2023-06-05T12:22:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T20:29:41+00:00","insertUserID":156479,"insertUser":{"userID":156479,"name":"Joe Luc","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Luc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T21:11:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156479,"lastUser":{"userID":156479,"name":"Joe Luc","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Luc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T21:11:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":55,"score":3,"hot":3372054423,"url":"https:\/\/community.smartsheet.com\/discussion\/106001\/automation-workflow-approval-use-form-to-request-additional-information-prior-to-approve-deny","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106001\/automation-workflow-approval-use-form-to-request-additional-information-prior-to-approve-deny","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106001,"commentID":379156,"name":"Re: automation workflow approval - Use form to request additional information prior to Approve\/Deny","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379156#Comment_379156","dateInserted":"2023-06-06T20:29:41+00:00","insertUserID":156479,"insertUser":{"userID":156479,"name":"Joe Luc","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Luc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T21:11:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106043,"type":"idea","name":"Forms: Contact List Default Setting Current User","excerpt":"When adding a contact list field to a form. I have noticed the need for an option of current user as a default setting. Some forms are repetitive and require an email often times that of the user filling out the form. This would greatly enhance the form experience and optimize user time.","categoryID":349,"dateInserted":"2023-06-05T22:51:39+00:00","dateUpdated":"2023-06-06T09:33:49+00:00","dateLastComment":"2023-06-06T09:37:16+00:00","insertUserID":159222,"insertUser":{"userID":159222,"name":"Lou Cav","url":"https:\/\/community.smartsheet.com\/profile\/Lou%20Cav","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p89Z6cXL3Ho!k8FafyWeRXo!b9B-ai4Twfw","dateLastActive":"2023-06-05T22:47:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-08T20:51:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":1,"hot":3372050635,"url":"https:\/\/community.smartsheet.com\/discussion\/106043\/forms-contact-list-default-setting-current-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106043\/forms-contact-list-default-setting-current-user","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106043,"commentID":378946,"name":"Re: Forms: Contact List Default Setting Current User","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378946#Comment_378946","dateInserted":"2023-06-06T09:37:16+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-08T20:51:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
