Multiple Nested Aggregations in Alternate State

[Anonymous]

Hi All,

I am trying to compute an aggregation of a monthly count divided by another monthly count in alternative state. The two equations compute correctly before I try to divide, but the division is calculating correctly. Is there something that I am missing?

Thank you in advance!

=Sum({[Curr]<[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]>}Aggr(Count({[Curr]<[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]>}Distinct(If(CancellationStatus='On-Assignment Cancellation' and DateType='CancellationDate', [Contractor ID]))),MonthYear))

/

Sum({[Curr]<[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]>}Aggr(Count({[Curr]<[Region]=$::[Region], [Primary Cost Center]=$:: [Primary Cost Center]>}Distinct(if(DateType='OADate', [Contractor ID])))*.9,MonthYear))

[sunny_talwar]

Would you be able to share a sample to check this out?