Forum Discussion

Anonymous

Not applicable

6 years ago

Create a new column based on distinct result

Hi, Good day. I need some help to get an accurate audit result from a given audited data. But first, let me share to your our audit process and give you samples. See details as follows: 1...

Community Champion

6 years ago

Hello Anonymous

I don't know how your last table is calculated. It shows 1200 for first Audit, but in your table you have 4 lines with 1200, 1200, 1000 and 1200. Is this a MAX-calculation?

Jimmy

Forum Discussion

Create a new column based on distinct result

Related content

Distinct count of users via Created By column

Create columns group

Distinctive Count across two columns

count distinct

Create New Table Based on DIstinct Values of One Column and Calculated Values of Another Column