You’re offline. This is a read only version of the page.
Announcements
Hello all,
I want to use the code below in a ForAll function then change DataCardValue28_2.Text with ThisRecord.'Wafer ID'.Text.
Share
ReportSet(RCACount,Sum(ForAll(Filter(RCAData, BatchID = DataCardValue16_2.Text && WaferID = DataCardValue28_2.Text),1),Value));
I know a cannot Set a variable within a ForAll function, but I cannot figure out a workaround for the above example. There will be up to 25 different possibilities in the collection.
Thank you in advance.
Rob
hey @rob4681
try this please:
All responses (
Answers (
14,605
Clear(TempCollection);
Collect(
TempCollection,
ForAll(
RCAData,
If(
BatchID = DataCardValue16_2.Text && WaferID = ThisRecord.'Wafer ID'.Text,
{Value: 1} // Adjust the value as necessary
)
)
);
Set(RCACount, Sum(TempCollection, Value));
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
