percentage formula

[ram]

Hi 

I am trying to create a formula to show the percentage of tasks
 Column A = Count (Pens)
Column B = DupCount (Pens)
Here Pens Column has Numeric ID Values like "41869 "
Could you please help me with Percentage formula

Thanks

[HamzaJ]

Hey @ram ,

Would the build in contribution function not work for you? (https://docs.sisense.com/main/SisenseLinux/dashboard-functions-reference.htm#StatisticalFunctionsSup...)

it automatically calculates the percentages.

If it doesnt work, you can divide those 2 functions and format the measure as percentage (e.g. Count(pens)/(dupcount(pens),all(tasks))

I assume that tasks is a category. So to calculate the percentage of pens per task the division needs to include all tasks. 

Hamza

[DRay]

Hello @ram,

I’m following up to see if the solution offered by @HamzaJ worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.