Net and Divide

[geeklarokcmie]

What tools to use to execute the below query:

Where ‘Column1’ = “XYZ” ensure the net of each ‘NumbersColumn’ by ‘Column2’, ‘Column3Date’, ‘Column4Date’ equal each other

[DataNath]

@geeklarokcmie what do you want to happen here? If this condition isn't met, do you want to flag these records? Filter them?

If you could provide a bit more info/context around your query, along with some mock data and the desired output you would expect then that would help to build out a solution.

[grazitti_sapna]

@geeklarokcmie , You can use filter tool if you want to filter out records on the basis of condition by specifying your condition in custom or you can use formula tool if you want to flag the data which matches your condition to True. If you want more specific answer to your question I would suggest to provide sample input and output so that I can provide you with sample workflow.

[geeklarokcmie]

@DataNath, @grazitti_sapna  If condition isn't met - I want to filter the records.

Column2	NumbersColumn	Column3Date	Column4Date	Column1
123456789	1600.00	7/25/2022	7/26/2022	ABC
123456790	1600.00	7/25/2022	7/26/2022	ABC
123456791	2000000.00	7/1/2022	7/26/2022	ABC
123456792	2460.68	7/26/2022	7/26/2022	ABC
123456793	1600.00	7/25/2022	7/26/2022	ABC
123456794	20.50	7/25/2022	7/26/2022	ABC
123456795	1032.00	1/10/2022	7/26/2022	ABC
123456796	1600.00	7/25/2022	1/25/2022	XYZ
123456797	14087.41	2/15/2021	1/26/2022	XYZ
123456798	115.02	7/25/2022	1/27/2022	XYZ
123456799	4000.00	7/25/2022	1/28/2022	XYZ
123456800	30000.00	1/6/2022	1/31/2022	XYZ
123456801	4000.00	7/25/2022	2/1/2022	XYZ

[DataNath]

@geeklarokcmie not sure I'm following the logic here as nothing looks like it will net out here. Can you provide a simplified list of the conditions that need to be checked i.e. what should equal what etc? Should be easy enough to filter once we have that.

[geeklarokcmie · Accepted solution]

I used Select, Filter and Tile Tools to get the desired result. Thanks