Kolom total in a report

[Eric12]

Hello,

I have a report where i calculate the expected cost, based on actual cost and percentage of completion. On row level i get the correct value, but the total is not correct. How come? hereunder my formula (last kolom rows are correct)

Verwachte Nacalculatie =

if(sum(Projectfases[PrjFas_Voortgangperc])>0,

    sum(NacalculatieoverzichtChecklist[NC_Verkoopbedrag])/sum(Projectfases[PrjFas_Voortgangperc]),

        if(sum(NacalculatieoverzichtChecklist[NC_Verkoopbedrag])<sum('Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag]),

            sum('Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag]),

                sum(NacalculatieoverzichtChecklist[NC_Verkoopbedrag])))

[Mahesh0016]

@Eric12 
Verwachte Nacalculatie =
IF (
SUM ( Projectfases[PrjFas_Voortgangperc] ) > 0,
DIVIDE (
SUM ( NacalculatieoverzichtChecklist[NC_Verkoopbedrag] ),
SUM ( Projectfases[PrjFas_Voortgangperc] ),
0
),
IF (
SUM ( NacalculatieoverzichtChecklist[NC_Verkoopbedrag] )
< SUM ( 'Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag] ),
SUM ( 'Voorcalculatieregel overzicht Checklist'[VCReg_Regelbedrag] ),
SUM ( NacalculatieoverzichtChecklist[NC_Verkoopbedrag] )
)
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Thank You!!

[Eric12]

@Mahesh0016 

Unfortunately this doesn't do the tric. I get a percentage per row as a result