Calculated Field not available as Summary Number
We're using Beast Mode to take the absolute value of another column, eg `abs(amount)`, and we'd like to use this value to calculate the summary number, but the field is not available in the drop down.
All of the other posts I've read simply say that the summary number has to be an aggregate value, and that doesn't seem to apply to this case, since we have no problem using the original column (amount).
Has anyone else run into this? Is the only solution to move the calculation to a dataflow?
0
Best Answer

Try this:
SUM(ABS(`Amount`))
ABS by itself doens't combine the numbers into a single value.
Sincerely,
Valiant**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Categories
 7.7K All Categories
 3 Connect
 919 Connectors
 244 Workbench
 477 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 446 Datasets
 37 Visualize
 198 Beast Mode
 2K Charting
 8 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 15 Manage
 36 Governance & Security
 27 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 14 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部