topic Re: Weird behavior in the division operation in App Development

Weird behavior in the division operation

vkish16161 — Wed, 09 Aug 2017 17:28:42 GMT

All,

I have a calculation like this:

(Both Numerator and Denominator work individually... but their division doesn't work)

Sum(Aggr(if(Sum([Is Engaged?])/(Count(distinct [Month Year])*4) >= 2,1,0) , [Party ID]))

Sum(Aggr(1,[Party ID])) // same as Count (distinct [Party ID])

What I have tried:

Put numerator and denominator separately in a variable and do the division on variables. Doesn't work

Use the div function.

Hoping I didn't do any silly mistake

stalwar1‌

Re: Weird behavior in the division operation

sunny_talwar — Wed, 09 Aug 2017 17:32:27 GMT

Don't see anything wrong here... are you using these in a variable and then doing the division through a variable?

Re: Weird behavior in the division operation

vkish16161 — Wed, 09 Aug 2017 17:48:49 GMT

Hey Sunny,

I tried that as well. Do you think this could be a bug? Weird thing is that the numerator and denominator work well individually in KPI boxes.

Also I've noticed that....

Sum(Aggr(1, [Party ID])) is yielding 1 more than Count(distinct [Party ID])

for e.g...

Sum(Aggr(1, [Party ID])) =101

Count(distinct [Party ID]) =100

Shouldn't both be the same?

stalwar1‌

Re: Weird behavior in the division operation

sunny_talwar — Wed, 09 Aug 2017 17:50:43 GMT

I would have thought that the two give the same number... not sure but may be there is a null Party ID, which is getting counted when using Sum(Aggr())...

Coming back to your division... would you be able to share a sample to check out?

Re: Weird behavior in the division operation

vkish16161 — Wed, 09 Aug 2017 17:55:28 GMT

"I would have thought that the two give the same number... not sure but may be there is a null Party ID, which is getting counted when using Sum(Aggr())..."

How can I exclude nulls in the Aggr? Sum({<[Party ID] - = {"*"}>} Aggr(1, [Party ID]))

Will provide sample data soon.

stalwar1‌

Re: Weird behavior in the division operation

sunny_talwar — Wed, 09 Aug 2017 17:56:37 GMT

May be this

Sum({<[Party ID] = {"*"}>} Aggr(1, [Party ID]))

Re: Weird behavior in the division operation

vkish16161 — Wed, 09 Aug 2017 18:07:41 GMT

Thanks bro. Will check it out.

Re: Weird behavior in the division operation

vkish16161 — Wed, 09 Aug 2017 19:36:30 GMT

lol. Things got weirder... The following nonsensical tweak made it work.

Variables:

numer = (Sum(Aggr(if(Sum([Is Engaged?])/(Count(distinct [Month Year])*4) >= 2,1,0) , [Party ID])) *2 )

denom = ( Count (distinct [Party ID]) * 2)

Expression:

$(numer) / $(denom)

Suspect: [Is Engaged?] is of Dual type. (Used dual function here)

stalwar1‌

Re: Weird behavior in the division operation

sunny_talwar — Wed, 09 Aug 2017 19:48:48 GMT

Difficult to say without looking at this...

Re: Weird behavior in the division operation

sasiparupudi1 — Thu, 10 Aug 2017 06:46:02 GMT

Try with a bracket in the numerator

(

Sum(Aggr(if(Sum([Is Engaged?])/(Count(distinct [Month Year])*4) >= 2,1,0) , [Party ID]))

)

Sum(Aggr(1,[Party ID]))