Need to do sum of Amount to Zero

%3CLINGO-SUB%20id%3D%22lingo-sub-2252027%22%20slang%3D%22en-US%22%3ENeed%20to%20do%20sum%20of%20Amount%20to%20Zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252027%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EHi%20Every%20One%2C%0A%0AI%26nbsp%3B%20am%20Facing%20issues%20In%20power%20apps%20while%20total%20amount%20need%20to%20zero%2C%20i%20have%20column%20in%20SharePoint%20List%20that%20column%20name%20was%20Document_Amt%2C%20the%20type%20of%20this%20column%20number.%20i%20am%20inserting%20Amount%20in%20Document_Amt%26nbsp%3BColumn.%20the%20Amount%20Can%20be%20either%20Positive%20or%20negative%20%2C%20but%20the%20total%20amount%20need%20to%20zero.%20when%20i%20enter%20first%20negative%20values%20Remaining%20Postitive%20values%20with%20decimal%20values%20%20the%20total%20amount%20was%20-2.8%20e-16%20it%20showing%20%2Cif%20i%20enter%20positive%20values%20decimal%20values%20and%20reaming%20if%20enter%20negative%20values%20the%20total%20amount%20calculate%20zero.%20i%20am%20sending%20screen%20shots%20can%20you%20help%20out%20this%20issue%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2252027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2255643%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20do%20sum%20of%20Amount%20to%20Zero%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2255643%22%20slang%3D%22en-US%22%3EI%20got%20solution%20for%20above%20issue%3C%2FLINGO-BODY%3E
New Contributor

 

 

 

Hi Every One,

I  am Facing issues In power apps while total amount need to zero, i have column in SharePoint List that column name was Document_Amt, the type of this column number. i am inserting Amount in Document_Amt Column. the Amount Can be either Positive or negative , but the total amount need to zero. when i enter first negative values Remaining Postitive values with decimal values  the total amount was -2.8 e-16 it showing ,if i enter positive values decimal values and reaming if enter negative values the total amount calculate zero. i am sending screen shots can you help out this issue

 

 

 

 

 

1 Reply
I got solution for above issue