0

Two fields sum

I have two fields and in the third it shows me the sum of these two fields. They must be summed if one of them is not equal to zero. Can anyone tell me the formula please

8 replies

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

    if 'number1' > 0 then
        'number1' + 'number2'
    end

    would that be right?

      • Ninox developper
      • Jacques_TUR
      • 1 yr ago
      • Reported - view

      iliper LTD This formula returns the sum of number1 and number2 only if number1 is not zero. In all other cases (including the one where number2 equals 0) this formula returns nothing (void). 
       

      Is this what you wanted?

    • Ninox developper
    • Jacques_TUR
    • 1 yr ago
    • Reported - view

    What should happen if one of the two is equal to zero?

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

      Jacques TUR thanks for help

      I had a difficulty more than that.

      I Have table where the recorded credit. To do this, there are fields 'Date + Time'   'Name' 'New Credit'  'Old Credit' and 'Total credit'. So, I need a formula for the 'old credit' field, which will sum up all the old credits  if the customer have a same name.

      TEST-3.ninox
      • Ninox developper
      • Jacques_TUR
      • 1 yr ago
      • Reported - view

      iliper LTD You talk about all the old credits, but I only see one credit field in your table. 
      You want to add a table with the old credits of the customers and add them up for each of them, right?

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

      Jacques  I need a formula for the 'old credit' field. When I write the client's name, I want to see his old credit

      • Ninox developper
      • Jacques_TUR
      • 1 yr ago
      • Reported - view

      iliper LTD Something like this ?

      TEST-4.ninox
    • iliper LTD
    • iliper_LTD
    • 1 yr ago
    • Reported - view
    Jacques TUR said:
    What should happen if one of the two is equal to zero?

     we had another way to see the amount of the old coedit, but we realized that this is not the right way

Login to reply

Content aside

  • 1 yr agoLast active
  • 8Replies
  • 85Views
  • 2 Following