ADDED COLUMN - FORMAT CURRENCY

%3CLINGO-SUB%20id%3D%22lingo-sub-2932778%22%20slang%3D%22en-US%22%3EADDED%20COLUMN%20-%20FORMAT%20CURRENCY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2932778%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%20Community%2C%3C%2FP%3E%3CP%3ETrying%20to%20format%20added%20column%20to%20show%20currency.%26nbsp%3B%20Have%20many%20combinations...I%20got%20nothin'%3C%2FP%3E%3CP%3EBelow%20is%20the%20formula%20used%20to%20group%2C%20sum%20and%20add%20new%20column%20%22AmountTotal%22.%3C%2FP%3E%3CP%3EAny%20assistance%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chudson002_0-1636142368652.png%22%20style%3D%22width%3A%20585px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324642i0DE30D7142ACD668%2Fimage-dimensions%2F585x100%3Fv%3Dv2%22%20width%3D%22585%22%20height%3D%22100%22%20role%3D%22button%22%20title%3D%22chudson002_0-1636142368652.png%22%20alt%3D%22chudson002_0-1636142368652.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chudson002_1-1636142392093.png%22%20style%3D%22width%3A%20629px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324644iBF9F2884E155A366%2Fimage-dimensions%2F629x32%3Fv%3Dv2%22%20width%3D%22629%22%20height%3D%2232%22%20role%3D%22button%22%20title%3D%22chudson002_1-1636142392093.png%22%20alt%3D%22chudson002_1-1636142392093.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EV%2FR%3C%2FP%3E%3CP%3Echudson002%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2932778%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Good Day Community,

Trying to format added column to show currency.  Have many combinations...I got nothin'

Below is the formula used to group, sum and add new column "AmountTotal".

Any assistance would be greatly appreciated.

chudson002_0-1636142368652.png

 

chudson002_1-1636142392093.png

V/R

chudson002

0 Replies