0

Help with if and cnt formula

I have a table and would like to bring back count results from people with specific categories on that table, identified by using the "choice" field. I know the formula to bring back the count result from the whole table, but need to single out those with a specific category or combining categories. (so using category = 1 or category = 2) as part of the count formula. Any ideas? THanks

2 replies

null
    • Pascal.1
    • 5 yrs ago
    • Reported - view

    Hi Garry,

    This can be done by putting a select command in your formula, or even more easy, using brackets syntaxt.

    Example :

    vNumber := cnt('MyTable'[category = 1].choice);

    with the "select" syntax this is :

    vNumber := cnt(select 'MyTable' where category = 1 or category = 2).'choice');

    With these "select" options, you're also able to bring informations from linked tables.

    • Garry_Walton
    • 5 yrs ago
    • Reported - view

    This is super, thanks so much Pascal.

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1693Views