Options

select distinct(field) from table

ric123ric123 Member Posts: 8
select distinct(field) from table

how can i do something like this in navision?

Comments

  • Options
    miguel.tiagomiguel.tiago Member Posts: 6
    Select distinct it's not possible in c/side
    There's a workaround that you can make using flowfields, but i'l need more information in what you want to to evaluate if it's possible.
  • Options
    samemerysamemery Member Posts: 60
    Hi,

    I want to be able to count the distinct records in the example:

    Table data:

    Sale # Customer #
    TS00001 C0000001
    TS00001 C0000001
    TS00001 C0000002
    TS00001 C0000003
    TS00001 C0000003


    I need a flowfield set up to tell me how many distinct occuances of customer number there are for the sale number X (in this case TS00001). So the flowfield in this occasion should return 3

    Is this possible?

    Thanks
Sign In or Register to comment.