Wouter - profile

Wouter · Nov 14, 2019

I have a table with costs with these fields: Date / Descr / Category (4 options) / Price / VAT / Quarter (calculated based on date) How would I get this report table as output in Airtable for Q1: Category / Price (sum per category) / VAT (sum per cat...

Wouter · Nov 21, 2019

Yes, so too much for manually adding date columns. However you could use my method to create a new view Entry where user types Total and in the next field the daily sales are calculated for the user as a ‘suggestion’ to type in in the field after tha...

Wouter · Nov 21, 2019

Ah, aggregates. Depends on how many days you want to look back. Only 3 I would do it like this: In Reports an extra calculated field Days ago (0,1 or 2) then a column today: if daysago=0 then Sales else “”. For yesterday and day before same formulas ...

Wouter · Nov 21, 2019

Make table Reports with fields: ID, date, city, #, sum And table Cities (name of the cities). In Reports: make a record for each day for each city, so 9 records in your example. Link field Cities to the table Cities. You should be able to do all the ...

Wouter · Nov 19, 2019

Shorter description: Add extra Sum table and under Name type Sum of Costs, so just one record in this table. Now go to Cost table and add a field with link to the Sum table. Link the first record to the one field. Copy this to the other records. In S...

Wouter · Nov 19, 2019

It’s not easy I think… Read this: How do I automatically add up all values in a column?

User Statistics

User Activity

Reporting: should I do this with Pivot or Page block

Re: HELP - Sales Tracking

Re: HELP - Sales Tracking

Re: HELP - Sales Tracking

Re: Using SUM in formula

Re: Using SUM in formula