Calculations on Grand Totals column
2 April, 2012
Hi,
I am trying to perform calculations on the Grand Totals column of the report, however Grand total columns are not even appearing in the calculated field option. Is it possible to make Grand Totals column appear? , so that these field can be selected to perform calculations while using calculated field option.
I have attached alongwith an excel sheet, i would like to see the output look alike the attached file. When i use calculated field for Margin %, Margin % is appearing against each month(i.e my column header) instead of Grand Total. Please suggest a soluton.
I am trying to perform calculations on the Grand Totals column of the report, however Grand total columns are not even appearing in the calculated field option. Is it possible to make Grand Totals column appear? , so that these field can be selected to perform calculations while using calculated field option.
I have attached alongwith an excel sheet, i would like to see the output look alike the attached file. When i use calculated field for Margin %, Margin % is appearing against each month(i.e my column header) instead of Grand Total. Please suggest a soluton.
Hi,
Unfortunately, there is no way to actully use a column total in a further calculation.
You would need to create a view based calculated field (that will calculate the total), and then use this calculated field in a future calculation at the report level.
You could aslo do the grand total calculation at the DB level and then use this field in a furhter calculation within the report.
An enhancement request has been created (TASK ID = 113193) .
Regards,
David
Unfortunately, there is no way to actully use a column total in a further calculation.
You would need to create a view based calculated field (that will calculate the total), and then use this calculated field in a future calculation at the report level.
You could aslo do the grand total calculation at the DB level and then use this field in a furhter calculation within the report.
An enhancement request has been created (TASK ID = 113193) .
Regards,
David
Hi David,
I am just wondering how this went and if this was ever implemented in YellowFin 7? I am trying to do a similar thing to the OP however it doesn't seem possible from what I can tell?
I've attached an example of a YellowFin report I've created where all the YellowFin data is in the blue header section. The green section is something I've added into Excel for demonstration purposes where:
% Of Calls is:
C?/$C$9 (e.g. C4/$C$9)
and
% Of Sales is:
E?/$E$9 (e.g. E4/$E$9)
Is this possible in YellowFin 7?
I am just wondering how this went and if this was ever implemented in YellowFin 7? I am trying to do a similar thing to the OP however it doesn't seem possible from what I can tell?
I've attached an example of a YellowFin report I've created where all the YellowFin data is in the blue header section. The green section is something I've added into Excel for demonstration purposes where:
% Of Calls is:
C?/$C$9 (e.g. C4/$C$9)
and
% Of Sales is:
E?/$E$9 (e.g. E4/$E$9)
Is this possible in YellowFin 7?
Hi Aaron,
What you are trying to achieve is possible using the Percentage of Total Advanced Function
Below is an example of the Percentage of Total Advanced Function applied to Invoice Amount column as well as the Athlete Counter column.
Please let me know if this is what you are after.
Regards,
Stephen
What you are trying to achieve is possible using the Percentage of Total Advanced Function
Below is an example of the Percentage of Total Advanced Function applied to Invoice Amount column as well as the Athlete Counter column.
Please let me know if this is what you are after.
Regards,
Stephen