Need help with Calculated column

Hi Users, I'm working on a report with a complex large dataset. Because I cannot reveal the data here, so instead I'm sharing a sample data with the same issue which I'm trying to solve. Below I've ...