Archive

Archive

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

Member

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

  • Contributor

    Hi all,

     

    Can anybody help @jkb out?

    Thanks!

  • Domo Employee

    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: 

    1. 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"

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In