Fixed Function At Two Levels (Or nested Fixed Function)
I have a data set that includes duplicate rows for products.
I'm using a fixed function to dedupe an aggregate sum of product prices because I only want one product row to contribute to the total.
The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID)
However, now I need to create a table that looks like this:
Store  Total Product Price  Total Price  Percent of Total 

A  100  300  0.33 
B  100  300  0.33 
C  100  300  0.33 
The challenge is that the Total Price calculation must be a sum of the total_product_price calculation that is fixed to the entire data set (including the deduplication in total_product_price performed by the Fixed Function).
Thank you in advance!
Best Answer

Have you tried using nested beastmodes? You may need to have nested beastmodes enabled by your CSM from Domo. You could try SUM(DISTINCT Price) FIXED (BY Product ID) as Beastmode 1 and then:
SUM(SUM(`Beastmode 1`) FIXED ())
If I solved your problem, please select "yes" above
0
Answers

Is ETL out of the question?
If I solved your problem, please select "yes" above
0 
@ColemenWilson , it is the plan right now, to group the values and dedupe there, but that will lock us into a those set aggregation fields and prevent responsive filters.
After hacking, I wasn't able to get the fixed function to work as we'd like.0 
Have you tried using nested beastmodes? You may need to have nested beastmodes enabled by your CSM from Domo. You could try SUM(DISTINCT Price) FIXED (BY Product ID) as Beastmode 1 and then:
SUM(SUM(`Beastmode 1`) FIXED ())
If I solved your problem, please select "yes" above
0 
@ColemenWilson  I will try this. It's actually what I thought of as I typed out the OP.
Thanks, I'll follow up if it works!0
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 298 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 100 SQL DataFlows
 616 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 729 Beast Mode
 54 App Studio
 40 Variables
 678 Automate
 173 Apps
 451 APIs & Domo Developer
 46 Workflows
 8 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 Domo Community Gallery
 32 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive