Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Below is a scenario where I am using a Count function to calculate category of an employee for a set of category say Category-1, 2,3 etc.
Now i have to show Base % of the category in the Output column based on the calculation logic provided in the sheet.
Here I am not getting the required output for the column. The calculation logic and sample data is attached in the image below.
expected syntax of the logic: count of employee / Sum of count = base %
Thank you in advance.
Count(SomeValue) / Count(Total SomeValue) would be the typical way.