how to round in set analysis

[jamiemcc]

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 · Accepted solution]

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

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/GeneralNu...

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[jamiemcc]

Thanks Rob. Top man.