At first I thought it was working, it would calculate the first line correctly (part weight * line qty). But if I try to change the qty the value doesn’t update. And if I enter more lines, they all get the same value.
Any idea what I’m doing wrong? I may be totally missing the mark here.
This is my interpretation of your explanation
I was trying something generic like OrderDtl.OpenLine=true as a filter to get any rows to the calculation step, but it doesn’t appear any are making it that far.
I added conditional dialogs which were giving me nothing, but I added curly bracket around my data view {OrderDtl}, and at least now it says ‘no match’
Any other thoughts on what I can try next?
I can see the row data in the function in dev tools. Within ds, there’s an OrderDtl table with at least one row. Kinda stumped on how to access it tho
It makes a subset of records based the criteria you provide. I think the word matches is special? It says the system generates a temporary data view named matches, containing your subset of records.
Then I was able to run my calculation on the subset, and just like Hannah said the result was automatically merged back into the original dataview. Magic!
dataview-condition, pretty dang cool!
Thanks again @hmwillett !