topic Re: how to round in set analysis in App Development

how to round in set analysis

jamiemcc — Wed, 20 Apr 2022 14:40:18 GMT

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 — Wed, 20 Apr 2022 16:14:59 GMT

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

jamiemcc — Thu, 21 Apr 2022 11:30:11 GMT

Thanks Rob. Top man.