Solved: how to round in set analysis - Qlik Community

jamiemcc · ‎2022-04-20

Hi Guys,

How do i round the total earnings part to two decimal places?

Please see logic below.

if(VConceptType=1,

Sum({< YYWeekIndex_US = {">=$(=Max(YYWeekIndex_US)-8)"},[SAP ID] = {'54'}>}[Judgment Total]),

If(VConceptType=3,

sum({< YYWeekIndex_US = {">=$(=Max(YYWeekIndex_US)-8)"},[SAP ID] = {'54'}>}[Total Earnings])))

Regards,

JAmie

rwunderlich · ‎2022-04-20

Round(sum({< YYWeekIndex_US = {">=$(=Max(YYWeekIndex_US)-8)"},[SAP ID] = {'54'}>}[Total Earnings]), .01)

rwunderlich · ‎2022-04-20

Round(sum({< YYWeekIndex_US = {">=$(=Max(YYWeekIndex_US)-8)"},[SAP ID] = {'54'}>}[Total Earnings]), .01)

jamiemcc · ‎2022-04-21

Thanks Rob. Top man.

how to round in set analysis