logo
Home JAVASCRIPTJAVACHASHPYTHONPHPCPPIOSSQLHTML
down
shadow

Income and Expense calculation


Income and Expense calculation
» mysql » Income and Expense calculation
By : Eric
Date : January 11 2021, 05:14 PM
it should still fix some issue In the future, I'd suggest posting some table details by using SHOW CREATE TABLE table_name which will allow us to better assist you.
You should be able to use a union and some grouping to get what you are after:
code :
SELECT
    Date,
    SUM(Income) as Income,
    SUM(Expense) as Expense,
    SUM(Income) - SUM(Expense) as Profit
FROM (
    SELECT
        due.date as Date,
        due.amount as Income,
        0 as Expense
    FROM due
    UNION ALL
    SELECT
        expenses.date as Date
        0 as Income,
        expenses.amount as Expense
    FROM expenses
)
GROUP BY Date


Share : facebook icon twitter icon
Crystal Report for Income and Expense wth opening and closing balance

Crystal Report for Income and Expense wth opening and closing balance

By : S.Roura
Date : March 29 2020, 07:55 AM
wish of those help Instead of writing the multiple queries.. you can do the required operation in crystal report itself.
Since you have Income and Expences separately. Take a main report and in that main report place 2 sub reports side by side in detail section. In sub report1 take the information of Income. Take all the required tables while making connection and link those tables in Links Tab of Database Expert. Similarly in second sub report take Expences tables and follow the same process to link the tables.
code :
Group1: Sub report1 `Income`..
        Sub Report2  `Expences`

Group 2: Sub Report1: Date
         Sub Report2: Date

Group 3: Sub Report1: Balance
         Sub Report2: Balance
table income and expense is better to have it together or apart

table income and expense is better to have it together or apart

By : user2023536
Date : March 29 2020, 07:55 AM
This might help you If they both store the same fields of information, there's no reason why you can't put them both in the same table with a field marked TransType that would be set to I for Income or E for Expense. Or, you'd know the difference based on whether the value is greater than or less than zero. This way, you could report them separately if necessary.
Programming logic for income tax calculation

Programming logic for income tax calculation

By : Satoru Oogami
Date : March 29 2020, 07:55 AM
it helps some times Is any one who can help me to create PHP or mysql Code for our Office employee salary tax table. Here is the base for our tax regulation.
dateTime difference income calculation

dateTime difference income calculation

By : Qurt Qwein
Date : March 29 2020, 07:55 AM
With these it helps Get total seconds from diff, divide them on 3600 and multiple on your rate.
Try something like this: http://www.php.net/manual/en/dateinterval.format.php#102271
income tax calculation python

income tax calculation python

By : kma1975
Date : March 29 2020, 07:55 AM
seems to work fine Q: How do I go about making a for-loop with a range 70000 and above?
A: Use the itertools.count() method:
Related Posts Related Posts :
  • Joining two foregin keys in the same table references the same primary key
  • Laravel: Load posts with privacy only to subscriber
  • Linux web server configuration for AJAX web page highly consumed CPU
  • How do I decrease an Integer in MySQL?
  • How can I delete the repeated data in MYSQL with over ten million data in it?
  • How Can I Optimize My MySQL Select Query?
  • How do I avoid invalid data with multiple programs writing to the same database?
  • I need to covert a timestamps from mysql (2019-08-16T10:36:03.562908+00:00) to 06-08-2019
  • How to select from two tables and compare the sum from first table if its greater than that in second table?
  • What could be the code for putting existing auto increment id in order?
  • Mysql Left Join of 3 tables and a one being joined twice
  • Mysql - How can I merge two json arrays of strings without duplicates?
  • Custom query in Spring Repository
  • Mysql inserts in the middle instead at the end of table
  • Creating tables and importing data from .sql files in Spring boot
  • How to Get Data from Multiple Database Dynamically?
  • Wordpress Access WP-Admin when installed in a sub directory
  • How to query fields with MySQL-Regex that contain thousand separator?
  • TomEE JPA MySql Configuration "An invalid Lifecycle transition was attempted"
  • Update a row with data from another row in the same table based on a similar field
  • SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:3306
  • Getting ER_PARSE_ERROR when using Intersect and multiple input vaules of email format
  • Laravel get many objects in one object
  • MySql: How do I sort a query by 2 specific categories and then by price?
  • Generating monthly report mysql
  • getting error in Sql Query incorrect syntax near ')'
  • MariaDB/MySQL select query replace json array of ids into concatenated values
  • How to create a MySQL Query to get sales for each date of month (Like Calendar)?
  • Insert query fails with error duplicate entry , where as select query returns null
  • MySQL - ORDER BY multiple words, then alphabetically?
  • With a one-to-many relation, how do you get every row of table A if table B doesn't reference some rows of A?
  • How to add temporary column with data with MYSQL?
  • Why is subquery join much faster than direct join
  • Under standing Update Queries, and how many sets one query can have
  • How to select multiple values in a subquery but have each value assigned to matching parent select value?
  • SQL getting a column to match multiple conditions in CASE
  • Converting date operation from MySQL to PostgreSQL
  • MySQL - Join these subqueries into a single query
  • Show the list of all product's names ordered along with first and last names of the customers
  • Mysql `OR` condition doesn't work with JOIN
  • how can I hide the data that my controller returns making a CRUD in Laravel & vue.js?
  • Sum of values for all accounts using the most recent date for each
  • MySQL Query between three tables (with also ORDER and LIMIT)
  • MySQL date_format () function vs SQL Like operator
  • How to Combine two select and two where clause?
  • How to convert this (strange formated) data ? a:5:{s:15:"nc_notification";s:1:"2";s:20:"iso_add
  • SELECT result within select isn't reachable?
  • How to call stored procedure at sqlfiddle?
  • How Do I convert this table from row to column?
  • Mysql check if table has any value
  • Mysql Index misbehave in rails
  • Calculate number of students per class without using a JOIN
  • "new ephemeral certificate expires too soon: current time:"M
  • How to write this SQL (about date and time)?
  • What would take longer to execute in a million row table LIMIT 37,22 or LIMIT 100037,22
  • Can't connect a spring-boot 2 service to mysql in a different container
  • Insert statement using variable in sql query
  • Getting all users except admins in many-to-many relationship
  • How to pass the data from modal to MYSQL using VueJS
  • MYSQL - get a row from a table in every database
    		•
    shadow
    Privacy Policy - Terms - Contact Us © festivalmusicasacra.org