Hello, I am relatively new to DOMO and was wondering if there
is any way to resolve the following issue. I have a simple table
chart with sales, cost, profit and margin displayed. I have enabled
a totals row at the bottom for sales, cost and profit using the
sum option. In the case of margin, I don't want to use the average
function for the margin column since that would not return a valid
value since all individual records above are weighted differently. I
tried adding an additional column to the right that uses a formula:
(SUM(`sales`) - SUM(`cost`) / SUM(`sales`)) * 100
and with this I can get a correct weighted average for margin
at the bottom of table but I don't really want to have to use
a duplicate column to the right of existing margin column,
especially since it appears I can't make the text color of the
values in this last column either white or transparent. If anyone
has any ideas on how to derive a margin based on the summary
of a few other existing summary columns I would really appreciate it.
Thanks.