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
-
if 'number1' > 0 then
'number1' + 'number2'
endwould that be right?
-
What should happen if one of the two is equal to zero?
-
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.
-
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? -
Jacques I need a formula for the 'old credit' field. When I write the client's name, I want to see his old credit
-
iliper LTD Something like this ?
-
-
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
Content aside
- 2 yrs agoLast active
- 8Replies
- 89Views
-
2
Following