7 Replies Latest reply on Sep 6, 2020 11:31 PM by Joseph_

    How do I divide the summary's evaluated value in formula instead of it's row?

    Joseph_

      Hello, I am creating a Saved Search using formulas to divide two Transaction Body fields containing a formula.

       

      Let's call this Field A:

      ABS(CASE WHEN {quantity}<0  THEN {quantity} ELSE 0 END)
      

       

      Let's call this Field B:

      CASE WHEN {quantity}>0  THEN {quantity} ELSE 0 END
      

       

      Here is what I am attempting to do with these two formulas:

      Field A / Field B
      

       

      This is the summary page of my item saved search:

       

      As you may have figured from the given two formulas, I would receive an error because when I click the Inventory Item, the transactions that make up this number is always divided by zero. The zero is entered from the ELSE statement. Field A is a positive quantity integer of sold items. Field B is a negative quantity integer turned into a positive number to indicate items returned.

       

      Do you know a workaround to perform the divide without having the system evalulate the components?

      Thanks in advance.