Including roundings using sum or only

[paul_ripley]

Hello I have some numbers in QV that I need to round. I set up an excel s/sheet to pick up the roundings  and load into the app (see attachment). I then want to add these roundings to the actuals. I was using the formuala

=num((floor((sum(
{<entity -= {"0148"},pl -={"X01*"},bussline_reclass = {[Private Equity]}, proceeds = {"Proceeds"}, period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}>}
[GPR GBP])*-1)   +500000,1000000)/1000000)+sum({<Input = {'R22'} >}PE) ,'#,##0;(#,##0);-')

but this seemed to duplicate the roundings. So I then changed it to 'only' instead of sum but then the whole formula brings back zero if there is no rounding . Can you help with what I am doing wrong Thanks

[sunny_talwar]

I think I am confused... what exactly do you mean when you say rounding? It doesn't seem like you are trying to round a number, right? like from Roun(10.2) = 10?