Search the Community
Showing results for tags 'subtraction'.
Hi I have a database in the database is a table called incomeuser1 there is a column called AMOUNT. Theres is also another table called expenseuser1 and a column called EXPAMOUNT. What code do i use to subtract one from other. For example if incomeuser1 AMOUNT was say 50.00. And expenseuser1 EXPAMOUNT was say 35.50 how do i subtract and echo the result as 14.50 using 2 decimal places ? Also if the sum was a minus figure how would i display that in red? Novice learner