Visokio website     Downloads     Video tutorials     KnowledgeBase  
Counting sub-strings: Using Subset - Visokio Forums
Counting sub-strings: Using Subset
  • aa1708 November 17, 2016 7:17AM
    Hi there, I have a table with PhoneNum attribute in it. In the PhoneNum field, I have numbers starting with 0845, 0843, 0871 and so on. How can I count the total numbers starting with 0845, 0843 and so on?
    Omniscope_Forum.JPG 14K
  •     paola November 17, 2016 8:41AM
    You could use a formula to 'cut off' the first 4 characters, then do aggregation on this field

    More Omniscope formulas can be found here
  • aa1708 November 17, 2016 11:15AM
    Thanks Paola, works perfectly
This discussion has been closed.
← All Discussions


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership