How to determine a status based on others columns and grouping functions

Anonymous — Tue, 15 Nov 2022 15:05:46 GMT

Hello gurus,

I'm face an issue to dermine a status of a row based on others columns and also linked to a calculatation of a global view

For example:

I need to determine the a status of SupplierValid (with value Yes/No)

based on following rules:

The Date DD/MM/YYYY column should be considered if exists in date range corresponding of Current date and last 3 months
The ErrorYN column should be Yes (according to the date range)
The number of raws respecting the previous rules should be greater or equal to 5

If all 3 rules are achived the status of SupplierValid should be set to Yes

Please find enclose an example

Thanks lot for your help 🤗

Re: How to determine a status based on others columns and grouping functions

v-jialluo-msft — Wed, 16 Nov 2022 03:13:35 GMT

^{Hi Anonymous ,}

^{Is the [SupplierValid] column the expected result you need?}

^{The results I filtered through several criteria didn't seem to get the expected results}

^{Please indicate further what you need}

^{Best Regards,}

^{Gallen Luo}