using sum distinct value in set analysis

[suzzymay]

Hi,

Trying to total up pool size for the most current date, but have duplicate records. 

eg

Date IP_pool Pool_size

20190915 1.120.0.0/20 4093

20190915 1.120.0.0/20 4093

Sum({<DynamicDateNum = {"$(=Max(DynamicDateNum))"}>}Pool_size)

This sums up all columns for date.

[Vegar · Accepted solution]

I would suggest to try identifying the data you want to calculate by other means than their distinct values. 

To calculate distinct use this

 Sum({<DynamicDateNum = {"$(=Max(DynamicDateNum))"}>}distinct Pool_size)

You could also be helped by an only calculation.

Only({<DynamicDateNum = {"$(=Max(DynamicDateNum))"}>}Pool_size)

[StarinieriG · Accepted solution]

Hi,

you could try with this expr:

Sum({<DynamicDateNum = {"$(=Max(DynamicDateNum))"}>}Aggr(Max(Pool_size),Date))

[sunny_talwar]

I would try this

Sum({<DynamicDateNum = {"$(=Max(DynamicDateNum))"}>} Aggr(
    
    Only({<DynamicDateNum = {"$(=Max(DynamicDateNum))"}>} Pool_size)

, DynamicDateNum, IP_pool))

[suzzymay]

Thankyou..