Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Expert,
I have a field named ActionCode which contains:
ZC/HRQCLNT/01
ZC/HRQCLNT/02
ZC/HRQCLNT/03
ZC/HRQCLNT/04
Now i want to Sum (Sales) where ActionCode containins number 01 and 03 using SubField function. So the function should like: SubField(ActionCode, '/', 3).
I've tried several ways like:
Sum({<ActionCode={$(=SubField(ActionCode,'/',3))={'01,'03'}}>} Sales)
or
Sum({<ActionCode={$(=Wildmatch(SubField(ActionCode,'/',3),'01','03'))}>} Sales)
But still not successfully yet.
Can anyone help me? Thank you.
Try like:
Sum({<ActionCode={"=Wildmatch(SubField(ActionCode,'/',3),'01','03')" }>} Sales)
Hi Danny,
I don't think in this instance subfield is necessary.
e.g.
Sum({<ActionCode={"*/01", "*/03"}>} Sales)
Marcus
Try like:
Sum({<ActionCode={"=Wildmatch(SubField(ActionCode,'/',3),'01','03')" }>} Sales)
Hi Marcus,
Thank you for reply.
I use SubField because the data is separated by the mark '/' and taken is the 3rd data from the separator. If using your solution, there may be the same data in the other separator. And for some other cases, I have to use SubField.
Can I implemented SubField inside Set Analysis?
Thank you.
Thank you Tresesco