user04693

Discussions

Adding percentage to total but cannot apply a 'Sub Total' in table
Hi, I have added a beast mode to calculate the % of the total in the table (refer to far left column). Beast mode formula: SUM(`EP`)/SUM(SUM(`EP`)) OVER () However, it now gives me an error when I insert a sub total in the table. How can I fix this issue so it can show the sub-total or total row in the table? Thank you.
SUM of CASE in Beast Mode
Hello, I would like to create a beast mode which can give me a % of a column in a table (e.g. % OCJ Actual) like such: Marketing IntentFY GoalOCJ Actual% OCJ ActualCOLLABORATION5,000,000500,00010%SECURITY5,000,000500,00010% The beast mode formula seems correct but I am getting this error 'An issue has occurred during…