Forum Discussion

d1x0nl30ng's avatar
d1x0nl30ng
Frequent Visitor
8 years ago
Solved

How to create a calculated distinct count if column (referencing another table)

I have a master progress table (Report1) which is dynamic (records being added regularly, and can have duplicate data for few columns~ *:* relationship) (to be very specific, SME, Manufacturer (Impor...
Need Help
  • d1x0nl30ng's avatar
    d1x0nl30ng
    8 years ago

    Thanks, i removed the MAX from the function and worked accordingly as what i expected.

    (Ignore the total count, i have a space in one of the data, this function worked even better detecting that as same)

     

d1x0nl30ng's avatar
d1x0nl30ng
Frequent Visitor
8 years ago

Thanks, i removed the MAX from the function and worked accordingly as what i expected.

(Ignore the total count, i have a space in one of the data, this function worked even better detecting that as same)

 

stretcharm's avatar
stretcharm
Icon for Memorable Member rankMemorable Member
8 years ago

great stuff