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"?

JasonCyphers_0-1605881731908.png

[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.

[Jake-MacLean]

Hi Bruno, 

Just came across this post and it is also not working for me.

Any pointers? When I fill it out all I see is COUNT({ObjectID})

I set up the data view and made sure the text widget was connected to it.

Thanks,

Jake

[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