0

Calculate the percentage if this result is negative

There is a field, "RESULT", where the result of the past day is shown. I need to calculate the percentage if this result is negative

9 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    Try the sign() command.

    if sign(RESULTS) = -1 then [code] end

      • iliper LTD
      • iliper_LTD
      • 1 yr ago
      • Reported - view

       Thanks for your reply Fred

      The formula doesn't work, it doesn't count. In the end, I need to calculate 10 percent if the result is negative

      • Fred
      • 1 yr ago
      • Reported - view

      Can you post your code?

      • iliper LTD
      • iliper_LTD
      • 1 yr ago
      • Reported - view

       Hello

      -max(Customer) * 'Customer DISC %'

      • Fred
      • 1 yr ago
      • Reported - view

        The original post asks to check for negative. Does that part work?

      Now you are having problem figuring out the discount?

      What kind of field is Customer?

      • iliper LTD
      • iliper_LTD
      • 1 yr ago
      • Reported - view

       Hi

      I solved the problem this way

      if 'Customer RESULT' < 0 then
          'Customer RESULT' * 'Customer DISC %'
      end

      • Fred
      • 1 yr ago
      • Reported - view

        I like the more common sense approach.

    • John_Halls
    • 1 yr ago
    • Reported - view

    This formula will return 1 if x is negative, and 0 if x is positive. You can then multiply it by your discount to return the discount or zero

    abs((sign(x)-1)/2)

    Regards John

      • iliper LTD
      • iliper_LTD
      • 1 yr ago
      • Reported - view

       Thanks for your reply

      Yes you are absolutely right, when negative, the value in the field is 1, but multiplying by one does not change anything. For example, when the result is -175 in the field where your formula is, the result is 1

Login to reply

Content aside

  • 1 yr agoLast active
  • 9Replies
  • 72Views
  • 3 Following