topic Re: Totals Function - Auto / Sum Issue in App Development

Totals Function - Auto / Sum Issue

Pragna — Fri, 22 Mar 2019 20:15:25 GMT

Hi All,

I am trying to get the total of a measure. But when setting the measure as Auto it giving a wrong total, But when I set the measure as Sum. It's giving the correct total value.

Below is the formula used for the measure.

=(Sum([Headcount Per Shift (people)])
*
(CEIL(round(sum(Load))/[Hours Per Day]))) / (CEIL(round(sum(Load))/[Hours Per Day]))

Any help is greatly appreciated.

Thanks

Re: Totals Function - Auto / Sum Issue

Anil_Babu_Samineni — Mon, 25 Mar 2019 03:38:25 GMT

Perhaps this?

Sum(Aggr((Sum([Headcount Per Shift (people)])
*
(CEIL(round(sum(Load))/[Hours Per Day]))) / (CEIL(round(sum(Load))/[Hours Per Day])), Dim1, Dim2,..)

// Dim1, Dim2 are based on your dimension. If more, you need to add to come expected result.

Re: Totals Function - Auto / Sum Issue

Pragna — Mon, 25 Mar 2019 18:38:22 GMT

Hi,

Thanks for your response.

I tried using the Aggr function as u mentioned but didn't get the expected result.

=(Sum([Headcount Per Shift (people)])
*
(CEIL(round(sum(Load))/[Hours Per Day]))) / (CEIL(round(sum(Load))/[Hours Per Day]))

Here ,

Measure 1 = (Sum([Headcount Per Shift (people)])
*
(CEIL(round(sum(Load))/[Hours Per Day])))

Measure 2 = (CEIL(round(sum(Load))/[Hours Per Day]))

Regards,

Pragna