0

Calculate quarterly results from two different tables.

Hello. I have a simple database for my business accountancy. The main part is a db of items I buy and seel; this let me calculate the profit and see how it gose on quartely, using the date of sale.

I also have a separate table for expenses not related to a specific item, like rent, which I need to subtract from my quartely profit to know the net profit of a quarterly.

I am trying to work on a new table which import the datas from the other two, but I can not figure out how to relate the dates... What kind of records should I create?!

1 reply

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    Hi, 

    You could use a formula like 

     

    sum((select MyTable where date >= "01.06.2019" and date <= "30.09.2019").profit)

     

    to sum up values from a different table.

     

    Your question would also be a good one for our webinar and it would be nice if you could bring it up there.

    At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for a live support where the participants' concerns will be solved. 

    You can register here for the webinar, which takes place every Tuesday at 18 o'clock CEST: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg

    Tank you very much.

    Kind regards, 

    Jörg

Login to reply

Content aside

  • 4 yrs agoLast active
  • 1Replies
  • 889Views