Count if

[flo]

Hey there,

I'm using Vensim DSS and what I try to do is to create (or use an existing?) function that works he way the "COUNT IF"-Command in IBM SPSS or MS Excel does. The model is connected to database and i want to count the number of certain values in the database list (for example COUNT IF VALUE=7). Is that somehow possible?

Thanks a lot!

[Administrator]

You will need to use something like

Code: Select all

sum ( if then else ( value[range!] = 7 , 1 , 0 ) )

[tomfid]

It's not entirely clear what you're counting, but GET DATA TOTAL POINTS might also be useful.

[flo]

The function sum ( if then else ( value[range!] = 7 , 1 , 0 ) ) works perfectly, thanks a lot.