Need a help

[#1]

Dear Community.

I need a help in counting the ItemCode with two conditions on two different fileds.

kindly find the attachment.

so please someone can help me out.

Thanks,

Mukram.

[perumal_41]

Hi

Use this expression usefule for u.

=Count(

{<ItemCode={"=ProcedurecatID=5 or ProcedureID=18"}>}

Distinct ItemCode)

[#3]

Dear Perumal A.

Thanks for your Reply.

it's not working .

i added some more records in the Inline table .

find the attachement.

[#4]

Dear Community.

Please somebody help me to solve the above issue it's urgent.

Thanks,

Mukram.

[Gysbert_Wassenaar · Accepted solution]

Try: =count({<ItemCode={"=count({< ProcedurecatID={5}>} ItemCode)>0"} >*<ItemCode={"=count({< ProcedureID={18}>} ItemCode)>0"} > } distinct ItemCode)

[#6]

Dear Gysbert,

It's working perfectly.

Thank you so much.

I highly appreciated your effort.

Thanks,

mukram.

[#7]

Hi,

How can I write the difference of these two expressions as one expression without changing the result.

=

Count({<ItemTransactions.ProcedureID={5},ItemTransactions.DBFlag={5}>}ItemCode

)

-

(count(
{<ItemCode={"=count({<ItemTransactions.ProcedureID={5}>} ItemCode)>0"} >

*
<ItemCode={"=count({< ItemTransactions.ProcedureID-={3,7,49}>} ItemCode)>0"},ItemTransactions.DBFlag={5} > } distinct ItemCode))

If possible, how can I use the result of this as a Select in field trigger on ItemCode field.

Any help would be greatly appreciated.

Thanks,

-Khaled.