Hi good day can anyone help me on my calculated column. On my table i want to the sum of Required base from Plan No. and Job No. column Sample - Plan No. 1001213651 with Job No. 22814282 it has a value of 4, 4, 4 and 20 = Total Required is 32OUTPUTJob No.Plan No.RequiredTotal Required22814282Object0022814282Object0022814282Object00228142821001182801002281428210011580710022814282100095770400228142821000254170002281428210028802080.080.0822814282100284528888228142821001213652442281428210012136514322281428210012136514322281428210012136514322281428210012136512032228142821000283298222281428210002823953322814282100025769633228142821000064371112281428210000643704722814282100006437017228142821000064370172281428210000643701723118955Object0023118955Object00231189551000284341484823118955Object0023118955Object002311895510002581791123118955100126583500231189551001265835002311895510018983130023118955100028329800

AllanBerces you can try this Column = CALCULATE(sum(job[Required]),ALLEXCEPT(job,job[Job No.],job[Plan No.])) pls see the attachment below

Post Prodigy

3 months ago

Solved

Sum base from two Column

Hi good day can anyone help me on my calculated column. On my table i want to the sum of Required base from Plan No. and Job No. column

Sample - Plan No. 1001213651 with Job No. 22814282 it has a value of 4, 4, 4 and 20 = Total Required is 32

OUTPUT