
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 02, 2020 04:21 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 02, 2020 09:06 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 02, 2020 10:24 AM
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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 02, 2020 10:56 AM
Yep, an additional column is one approach. Another is to create a new view and filter for values >= zero.
