How do I get the value of a variable given another defined variable?

[#1]

Hi all,

I'm trying to make a text box where I can do something along these lines.

=Count({<Status={'In Production'}>} Status)

The problem is that the number should come out to being about 4,000 but it's only coming out to 3.

When I make a multi box, I can select the "ITMS Type", "Status" (which is In Production), and then I can get a count of those two combined variables because I sent a count command using SQL.

What I want is the count of all ITMS Types with the Status of "In Production". How do I go about doing that?

[Gysbert_Wassenaar]

Try counting [ITMS Type] values instead of Status: =Count({<Status={'In Production'}>} [ITMS Type])

[lironbaram]

maybe something like this

sum(aggr(Count({<Status={'In Production'}>} Status),["ITMS Type]))

[sunny_talwar]

Would you be able to share a sample to show the issue you are facing?

[#5 · Accepted solution]

I worked around it by using SQL code "SQL SELECT * FROM db WHERE db.tbl.[Application Status] = 'In Production'"

After that I did "=Sum([Count of ITMS Type])" in the Text field of the Text Object.

Problem solved.