Including roundings using sum or only

paul_ripley — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Including roundings using sum or only

sunny_talwar — Fri, 21 Dec 2018 12:21:02 GMT

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?

topic Re: Including roundings using sum or only in QlikView

Including roundings using sum or only

Re: Including roundings using sum or only