Hello,
I am new with airtable and have already a problem with a formula.
This is the formula that I am using:
IF({Amount SEK}> 0,{Amount SEK}{exchange rate},IF({Paid AC}=0, {Amount €},{Amount €}-1))
If I have a checked “Paid AC” the “Amount €” should be a negative amount and this is working, but in the sum I see that negative amount is 2 times subtracted. See screenshot link.
ht@@tps://imgur.com/a/BU9giaL
Negative numbers counted 2 times
Hmmm, that sum seems correct to me - 694.96 is exactly the product of the netted values in the Formule Amount column. What am I missing?
Hmmm, that sum seems correct to me - 694.96 is exactly the product of the netted values in the Formule Amount column. What am I missing?
Yes, that’s correct but I want the sum of the positive numbers and that’s 1012,25.
How can i get this number somewhere?
Already solved with extra column and following formule: IF({Paid AC}=1, 0,{Formule Amount})
Yes, that’s correct but I want the sum of the positive numbers and that’s 1012,25.
How can i get this number somewhere?
Already solved with extra column and following formule: IF({Paid AC}=1, 0,{Formule Amount})
Yep, an additional column is one approach. Another is to create a new view and filter for values >= zero.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.