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

jkb

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

kshah008

Hi all,

 

Can anybody help @jkb out?

Thanks!

ilikenno

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