Creating new field using formula

Hi Team,

Hope you are well.

I need help. I have two files ( file 1 and file2) and i need to create a new calculated column based on the two files.

Please find attached the snapshot.

The newly created column is Percentage of x.

Thanks,

Sri

Datasets

Expression

Accepted answers

Here is how you can do it.

Workflow:

Hope this helps : )

Here is how you can do it.

Workflow:

Hope this helps : )

Thank you so much. 🙂 as always.

Will go through it and let you know

Cheers,

Sri