Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Issue with Chart for Income/Expenses

Featured Replies

  • Newbies

Hello everyone,

 

I'm trying to create a chart for the incomes and expenses of a certain customer however the main problem is the 'date' field to use.

 

The database is the following:

 

1 table for customers

1 table for incomes

1 table for expenses

 

The 'customers' table is related to the other 2.

 

I need to create a date field that can be used for both income and expenses in order to generate the chart.

In other words it has to answer to : "Show me all the incomes and expenditures of a certain year...now!" :)

 

At the moment if I use a calculated date field from the 'incomes' table the line of the expenses appears horizontally straight.

 

 

Hope it makes sense :)

Thanks.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.