Mumbai, IN

Welcome to the Mumbai User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

Division based on TRUE FALSE values

Kuldeepmathur
7 - Meteor

Hi,

 

I want to create a separate percentage column on the basis of the Status value which is True & False.

 

The condition is EMP_ID where Termination Status is True/EMP_ID where Termination Status is False(Month wise).

 

Thanks,

Kuldeep

 

1 REPLY 1
VDhawle
5 - Atom

Hello Kuldeep,

 

The method that I used is very simple, there were some missing elements that needed to be reordered. The data is fantastic and took some time for me to think for what to be achieved. 

 

I have added a Union tool to club both output from summary. Later, reordered monthly using a sort tool and finally used a multi row formula tool to do the required calculation.

 

I have copied the expression below so that people in community can make use of it.

 

If you think this is a solution that you are looking for will this solve your current need?  I hope so.

 

Cheers,

Vinod D