Count IF-Else statement

[awalhashim]

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. 

[Thiago_Justen_ · Accepted solution]

You could try it out:

Count({<"Interest.BU"= {"=Booking.BU"}>}SaleID)

Or

Count(If(Interest.BU = Booking.BU,SaleID))

Cheers

[awalhashim]

Hi Thiago thanks for replying.

It doesn't work. Still return 0 when its counting.

[Thiago_Justen_]

Could you please share a mockup?