How to duplicate IF function from excel

Hello,

I want to create a column ‘Predicted fraud’ in which if it is Scenario A it will use Full name match column numbers and if it Scenario E it will use Full name and DOB match column.

I have tried ifelse and sumover functions, but it kept giving errors

@Bujinlkham_Boldbaata - Thank you for posting your query. ifelse() should be the function that you would need to use here. Please go through the documentation which contains examples as well. Hope this helps!

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

It gives me following error

[Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination error]

Can you please share the expression that you are using?

1 Like