Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how to compare two measures in set analysis?
Need to find count(Id) who's sum(A)> Sum(B).
Count({<sum(A)> Sum(B)>}ID) //for each ID need to compare sum(A) with Sum(B) & need to take count for each day.
Try something like:
Count(Distinct {<ID={"=sum(A)> Sum(B)" } >} ID)