Hi guys,
Please help me.
How to compare two collection column value. and return the result If the particular column value both is same is zero otherwise any number.
thanks.
Solved! Go to Solution.
Hi @Gelos,
Have you solved your problem?
Do you want to compare the values from 2 two columns belonging to different collections?
Could you please tell me more details about your need, what do you want to achieve?
Based on your description, you want to compare 2 columns from different collections, I assume that both of them are Text type.
Add a Label and set the Text property as below:
If(CountRows(Filter(Product,Title in Tracking.Title))=CountRows(Product.Title),0,CountRows(Product.Title))
Note that I have two columns Title in Product and Tracking.
Check if this could solve your problem.
Hi @Gelos,
Have you solved your problem?
Do you want to compare the values from 2 two columns belonging to different collections?
Could you please tell me more details about your need, what do you want to achieve?
Based on your description, you want to compare 2 columns from different collections, I assume that both of them are Text type.
Add a Label and set the Text property as below:
If(CountRows(Filter(Product,Title in Tracking.Title))=CountRows(Product.Title),0,CountRows(Product.Title))
Note that I have two columns Title in Product and Tracking.
Check if this could solve your problem.
User | Count |
---|---|
253 | |
113 | |
92 | |
48 | |
38 |