Dynamic Content Expression

[JasonCyphers]

Trying to have text that counts the number of records in a database in which a specific attribute is "Yes".

What formula do I need to enter into the Expression box, so that if 3 of the 5 records have "Yes" for a specific attribute, then the number displayed is "3"?

[TKSHEP]

Yes, I did and that still did not work.  It shows a count but not the correct number of the number that is in the data view, data view records are correct not the text number.

[doronwen]

Hey @BrunoSousa1 

Does  the expression builder for Dynamic content allows you to divide two sums?
I need to get a percentage calculated.

This is what I came up with, but it does not work:

(SUM({Material Capacity}))/(SUM({Material Inventory}))*100

How would you write it?

Thanks