i need to build a formula that looks like this: (MAX(`Min Order Cards`) `Min Order Cards`)
in New to Domo
i need to build a formula that looks like this: (MAX(`Min Order Cards`) `Min Order Cards`)
i think I need to add a field to the dataflow for the max number, and then I can use that new field in my beast mode;
this formula above doesn't work in beastmode
0
Comments

Hello @jkb,
You are correct. This calculation will need to be done in a dataflow.
You should be able to do it in a SQL dataflow using the following query:SELECT
(SELECT MAX(`Min Order Cards`) FROM input_dataset)

(SELECT MIN(`Min Order Cards`) FROM input_dataset)
AS 'Difference'
FROM input_dataset**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
 10.6K All Categories
 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 251 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 62 Kowaza
 295 仲間に相談
 649 ひらめき共有