0

Subtotal

Is there a way to create subtotals per day. I have transactions per day and would like to have a subtotal per day on order to compare with a budget per day. 

2 replies

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    Create a new table view. Group by day. Tell the amount column to show the sum.

    Birger

    • Support
    • 5 yrs ago
    • Reported - view

    Hi,

    You can sum the totals using the function sum(). Usage is sum(Invoice.Amount). 

    If you need script specific for your database, please mail us your query and table screenshot at support@ninoxdb.de.

    Regards,

    Sakshi- Ninox

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1466Views