Page 1 / 1
I came across the same need just recently.
The best I could do is the use the average function for the % but averaging percentages is not the same as the true percentage of the totals because the weight of each line is not taken into account.
The best I could do is the use the average function for the % but averaging percentages is not the same as the true percentage of the totals because the weight of each line is not taken into account.
I totally agree. My current work-around is exporting the file and calculating it on spreadsheets. This method is not scalable.
Hi Jennifer,
We have released only Phase 1 of formula fields where you can work on a single row
formula. But I understand the phase 1 does not solve a lot of usecases like the ones you have mentioned above. We will be improving formula capability in Reporting and Data Management to accurately calculate the case you mentioned. Meanwhile, can you share a screenshot of the report or the Fomula screen? This helps us in understanding it more.
We have released only Phase 1 of formula fields where you can work on a single row
formula. But I understand the phase 1 does not solve a lot of usecases like the ones you have mentioned above. We will be improving formula capability in Reporting and Data Management to accurately calculate the case you mentioned. Meanwhile, can you share a screenshot of the report or the Fomula screen? This helps us in understanding it more.
Hi Rakesh,
I would love to share with the screenshots with you on a seperate email. What is your email address?
I would love to share with the screenshots with you on a seperate email. What is your email address?
Email me at rrkondam@gainsight.com
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.