I am making a game tool. I have an arbitrary number of area shields. My goal is to add up the damage of an arbitrary number of area shields. The damage lookup table is named areadata. The lvl of area shield chosen in drop down can be used to lookup the damage in the areadata table.
I have not quite figured out the easiest way to make the multiplication then arrive at a total sum. Thank you.
If the calc is based on something in your data type, then you can use an expression to do a search for the records that meet your criteria and then reflect the result in a text field. In that case, you won’t need a calc button.