i need to build a formula that looks like this: (MAX(`Min Order Cards`) -`Min Order Cards`)

jkb
jkb
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

Comments

  • kshah008
    kshah008

    Hi all,

     

    Can anybody help @jkb out?

    Thanks!

  • ilikenno
    ilikenno

    domo

    💎

    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

Categories