Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Exactly how the title is - I would like to grab the count of open "Accounts" when a user selects a value from the filter pane (Region).
My syntax -
Count({<[Open/Close] = {"Open"}, Region = {'$vRegion'}>} [Open/Close])
In my variable set up, I have made the definition to be = 'Region'. I think my formula should be working. I think the problem occurs with my variable set up. Currently my variable set up is vRegion = Region (the column/field). Should this be something else?
Ok got it the parentheses were missing. That fixed it. Thanks!