Hi, 

I believe you can use the same logic as the first part of your formula:
List.’Dimension Property’ = Dimension.”item”

Because “No Vendor Name” is found multiple times in ‘PL GL Data.’Final Vendor Name’, you have to reference the dimension itself.

That would give something like:

IF('PL GL Data'.'PL Cat 1'='PL Cat 1'."Non-Headcount Costs",COUNTALLOF('PL GL Data'.'Final Vendor Name' = ‘Final Vendor Name’."No Vendor Name"))

assuming your dimension is named ‘Final Vendor Name’, otherwise, write the dimension block name instead.

Hope it helps.

Best,
Benoit

Hi Benoit,
Thank for your suggestion. The property is resolved now.

But I’m not getting the correct COUNT of “No Vendor Name” for this formula. The count that I get from manually applying filters in the transaction list is different from this formula.

Am I missing anything else to add in here to arrive at the correct count?

 

Hi @keerthanaramesh 
 

Please try Below formula:
 

IF('PL GL Data'.'PL Cat 1'='PL Cat 1'."Non-Headcount Costs", if('PL GL Data'.'Final Vendor Name' =‘Final Vendor Name’."No Vendor Name",1,0)mRemove:'PL GL Data'])

Hi, 

I recreated a List as follow

If you want the count, you’re not even forced to do an IF, you can just filter your list to have the count of the desired items, which would be more performant.

Here is the formula:

'PL GL Data'.Name

bfilter: 'PL GL Data'.'PL Cat 1' = 'PL Cat 1'."Non-Headcount Costs"]

bfilter: 'PL GL Data'.'Final Vendor Name' = 'Final Vendor Name'."No Vendor Name"]

bREMOVE count: 'PL GL Data']

Hope it helps.

Thanks