Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a straight table consist of SaleID, Interest.BU, Booking.BU. Since both BU from Interest and Booking is many-to-many relationship so i added an expression and come out with correct BU.
if(Interest.BU = Booking.BU,count(SaleID),0)
Now i want to count the SaleID and InterestID in which in another expression but seems to fail to get the correct no. it counting the whole id. i want the something like this.
Count(if Interest.BU = Booking.Bu)
which met the condition above.
Hi Thiago thanks for replying.
It doesn't work. Still return 0 when its counting.