Forum Discussion
IF function for multiple FILTERS
Hi All, I have a requirement to create a new column for the below-given table: Thank you in advance
| order No | Cust Name | Y/N? | Revenue class | Amount | New column |
| 111 | ABC | Y | Apple | 100 | Flex |
| 112 | XYZ | N | Apple | 22 | Flex |
| 113 | ABC | N | Apple | 300 | Flex |
| 114 | XYZ | Y | Orange | 66 | Flex |
| 115 | DFG | N | Apple | 667 | NonFlex |
| 116 | DDF | Y | Orange | 567 | NonFlex |
| 112 | XYZ | N | Mango | 345 | Flex |
| 111 | ABC | Y | Mango | 349 | Flex |
New column = I want the results as flex or nonflex.
- The actual requirement is to link flex or non flex for each row based on the "distinct" order number and distinct customer name by column name Y/N?
- Flex: If column Y/N? equals "Y and N", then it should be Flex for those distinct orders and distinct customers
- NonFlex" If column Y/N? "Y OR N", then it should be NonFlex for those distinct orders and distinct customers
2 Replies
ManjunathaEP , Create a new column like
If(calculate(distinctCOUNT([Y/N?]), filter(Table, [Cust Name] =earlier([Cust Name])))+0=2, "Flex"," NonFlex")
