percentage formula | Help and How-To

ram · 2025-04-24T12:28:00.170000Z

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 formulaThanks

DRay

·1 year ago

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.

DRay

·1 year ago

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.

DRay

·1 year ago

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.

HamzaJ

·1 year ago

Hey ram ,

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

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