Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have just update cummulative sales on nozzles and i cant able to display cummulative percentage which i have used function like
nozzle sales i display cummulative nozzle by using Rangesum(above(sum(totalsalesbasedon nozzles),0,rowno(total))) and it display
everything and cummulative nozzle not in datasheet and it is on qlik inner and while i calculating cummulative nozzle is there.
Please Do needful
what is the approached to be followed.
num(((Sum([TOTAL SALES BASED ON NOZZLES (Ltr) (S)])/sum(TOTAL [Cummulative Variation])))*10,'##.00%') but values didnt not come as expected is there any code on this and please update .
I just want to display percentage cummulative sales
try this.
num((rangesum(Above(Sum([TOTAL SALES BASED ON NOZZLES (Ltr) (S)]),1,RowNo()))+sum([TOTAL SALES BASED ON NOZZLES (Ltr) (S)]))//sum(TOTAL [Cummulative Variation])))*100,'#,##0.00%')