Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Would you be able to share a sample to check this out?