How to code to display the value for only the 75T type? If I do {{#1001}} the number is the SUM of both rows. Also, how to code to display the Test Percentage?
we recently added a case about the functionality you are looking for, the where function.
You can now filter out data that have certain values. You can find here how to : CASE: where attribute
Further, I think that also answers your second question about the Test Percentage? You can call upon the variable in your for-loop.
If you need further help with that, don’t hesitate to upload your code so we can have a further look.
Thanks @Sofie_Cleemput. I do notice that in the case you shared, it still requested user to make a selection in the input mode so that the value can passed to the calculation. My question would be if it is possible when I code it I directly do something like {{ #1001 | where:“Type”=“75T” }}. I know this is not a valid code, but I just want to inquire if I can code with logic like this? Please advise.