Subtraction Formula on Column format Number

%3CLINGO-SUB%20id%3D%22lingo-sub-2585953%22%20slang%3D%22en-US%22%3ESubtraction%20Formula%20on%20Column%20format%20Number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2585953%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Can%20anybody%20give%20me%20an%20Idea%2C%20how%20to%20write%20formula%20Subtraction%20on%20SharePoint%20List%20with%20Column%20format%20Number%2C%20because%2C%20it%20can't%20work%20and%20can't%20save.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESubtraction%20formula%20is%20TotalCategoryBudget%20-%20Realisasi.%20I%20Need%20in%20format%20column%20Number%2C%20because%20if%20with%20calculated%20it%20will%20be%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20everyone%20who%20support%20me.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lucas_ignatius_0-1627286308105.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298331iF832C8C10EEC9DF6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22lucas_ignatius_0-1627286308105.png%22%20alt%3D%22lucas_ignatius_0-1627286308105.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2585953%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2586193%22%20slang%3D%22en-US%22%3ERe%3A%20Subtraction%20Formula%20on%20Column%20format%20Number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2586193%22%20slang%3D%22en-US%22%3EYou%20can't%20do%20it%20with%20a%20number%20column%2C%20it%20needs%20to%20be%20a%20calculated%20column.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2586507%22%20slang%3D%22en-US%22%3ERe%3A%20Subtraction%20Formula%20on%20Column%20format%20Number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2586507%22%20slang%3D%22en-US%22%3ESo%20what%20function%20for%20calculated%20in%20there%3F%3CBR%20%2F%3EAnd%20how%20to%20add%20symbol%20if%20using%20calculated%20column%3F%3C%2FLINGO-BODY%3E
Contributor

Hi, Can anybody give me an Idea, how to write formula Subtraction on SharePoint List with Column format Number, because, it can't work and can't save.

 

Subtraction formula is TotalCategoryBudget - Realisasi. I Need in format column Number, because if with calculated it will be work.

 

Thanks for everyone who support me.

lucas_ignatius_0-1627286308105.png

 

2 Replies
You can't do it with a number column, it needs to be a calculated column.
So what function for calculated in there?
And how to add symbol if using calculated column?