Formula

[ram]

Hi 

I want to show the total task percentage 
i have a task count which i achieved by  dupcount([Student id ]) = 337 
i got the total count  which is Grand total which i got by grand total option on a task  which is 22,315

now my formula should show 22,315/337 = 66.21%
could you please help me with the formula

Thanks

[DRay]

Hello @ram,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer. 

[TriAnthony · Accepted solution]

Hi @ram,

Is Task the category/slicer in the widget? If yes, you can calculate each task’s contribution to the grand total using this formula:

DUPCOUNT([Student ID]) / SUM(Task, (DUPCOUNT([Student ID]))

The denominator in this formula uses a feature called multi-pass aggregation. You can find more information and an example here: https://docs.sisense.com/main/SisenseLinux/build-formulas.htm#combine-data-aggregate-functions.

Let me know if you have any follow-up questions.