Need help on expression creation

[agni_gold]

Hi All , I want to create an set analysis expression for below rule ,

Count(Distinct(Group_Name) )where sum(SAVINGS_USD < 0) over partition of group_Supplier

[sunny_talwar]

May be like this:

Count(DISTINCT {<Group_Name = {"=Sum(SAVINGS_USD) < 0"}>} Group_Name)

Please provide a sample if the above doesn't work for you.

[agni_gold]

what about over partition of group_Supplier

[sunny_talwar]

That is what I am not sure about. Can you provide few rows of data with expected output you are looking to get?