7 Replies Latest reply: Dec 28, 2016 8:04 AM by Pavol Gavaj RSS

    Round numbers (%) in expression


      I try get MAX values in bar chart for each category (picture below). I got it, but I have a problem with round numbers. May I ask for help?

      This is code, which I need for MAX values in Category in %. It works fine.

      =if(RANK(AGGR(Sum({<DATUM_ID = {">=$(=datum_od) <=$(=datum_do)"}>} PRIJATE)/ Sum(TOTAL <AREA> {<DATUM_ID = {">=$(=datum_od) <=$(=datum_do)"}>} PRIJATE) ,AREA, TYPE)) = 1,rgb(80,80,80))

      p.s. "DATUM_ID" means DATE