SharePoint List Cash Balance

%3CLINGO-SUB%20id%3D%22lingo-sub-3217759%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Cash%20Balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217759%22%20slang%3D%22en-US%22%3EHi.%20I'm%20trying%20to%20create%20a%20simple%20SharePoint%20List%20for%20cash%20in%20and%20out%20of%20the%20office.%20I%20was%20trying%20to%20have%20the%20debit%20and%20credit%20amount%20in%20the%20same%20coloum%20with%20out%20having%20to%20put%20a%20minus%20(-)%20in%20front%20on%20the%20debit%20amount.%20To%20then%20use%20the%20Total%20sum%20for%20that%20coloum.%20I%20have%20managed%20to%20put%20a%20minus%20in%20front%20of%20the%20debit%20amount%20using%20a%20calculated%20coloum%20along%20with%20a%20choice%20coloum.%20However%20it%20does%20not%20allow%20the%20Total%20sum%20on%20that%20calculated%20coloum.%20I%20have%20also%20had%20a%20separate%20coloum%20for%20debit%20and%20credit%20amounts%20with%20Total%20sum%2C%20but%20don't%20know%20how%20to%20then%20take%20the%20debit%20total%20from%20the%20credit%20total.%20Also%20is%20there%20a%20way%20to%20have%20the%20total%20sum%20for%20the%20column%20at%20the%20top%20rather%20than%20the%20bottom.%20I%20know%20this%20can%20all%20be%20done%20in%20Powerapps%2C%20but%20was%20hoping%20to%20keep%20it%20simple%20and%20just%20use%20a%20SharePoint%20List.%20Any%20suggestions%20please.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217759%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217776%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20Cash%20Balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217776%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318934%22%20target%3D%22_blank%22%3E%40David20%3C%2FA%3E%26nbsp%3Bif%20you're%20not%20adding%20a%20minus%20symbol%20(-)%20for%20debits%20then%20how%20are%20you%20differentiating%20credits%20from%20debits%3F%20The%20easiest%20thing%20is%20just%20to%20put%20the%20-%20in.%26nbsp%3BYou%20are%20correct%2C%20you%20cannot%20have%20the%20total%20on%20a%20calculated%20column.%26nbsp%3BNo%2C%20the%20total%20is%20aways%20at%20the%20bottom%20and%20cannot%20be%20placed%20at%20the%20top%20of%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi. I'm trying to create a simple SharePoint List for cash in and out of the office. I was trying to have the debit and credit amount in the same coloum with out having to put a minus (-) in front on the debit amount. To then use the Total sum for that coloum. I have managed to put a minus in front of the debit amount using a calculated coloum along with a choice coloum. However it does not allow the Total sum on that calculated coloum. I have also had a separate coloum for debit and credit amounts with Total sum, but don't know how to then take the debit total from the credit total. Also is there a way to have the total sum for the column at the top rather than the bottom. I know this can all be done in Powerapps, but was hoping to keep it simple and just use a SharePoint List. Any suggestions please.
2 Replies

@David20 if you're not adding a minus symbol (-) for debits then how are you differentiating credits from debits? The easiest thing is just to put the - in. You are correct, you cannot have the total on a calculated column. No, the total is aways at the bottom and cannot be placed at the top of the list.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Hi Rob. The problem of not having an automated minus (-) on the debit amount following selecting debit from the choice coloum is people forget. Thanks David