Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try: =count({<ItemCode={"=count({< ProcedurecatID={5}>} ItemCode)>0"} >*<ItemCode={"=count({< ProcedureID={18}>} ItemCode)>0"} > } distinct ItemCode)
Hi
Use this expression usefule for u.
=Count(
{<ItemCode={"=ProcedurecatID=5 or ProcedureID=18"}>}
Distinct ItemCode)
Dear Perumal A.
Thanks for your Reply.
it's not working .
i added some more records in the Inline table .
find the attachement.
Dear Community.
Please somebody help me to solve the above issue it's urgent.
Thanks,
Mukram.
Try: =count({<ItemCode={"=count({< ProcedurecatID={5}>} ItemCode)>0"} >*<ItemCode={"=count({< ProcedureID={18}>} ItemCode)>0"} > } distinct ItemCode)
Dear Gysbert,
It's working perfectly.
Thank you so much.
I highly appreciated your effort.
Thanks,
mukram.
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.