Forum Discussion

venkatasuresh_g's avatar
venkatasuresh_g
Icon for Helper IV rankHelper IV
1 year ago
Solved

Matrix Visual wrong column subtotals for percentages

Hi       I amd caclulating percentage from attendance table, using simple formula "Compliance% = [Total_attendance]/[#workdays]" , when I use this  in a table it works fine , when I use the same in...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi venkatasuresh_g ,

     

    I want to acknowledge valuable input provided by tharunkumarRTK . The ISFILTERED function and the ISINSCOPE function are very helpful for the handling of hierarchical structures. Did the blog link provided by tharunkumarRTK  help you with your problem?  If solved, please mark the helpful answer as a solution this will help more people, if not please point it out.

     

    Best Regards,

    Neeko Tang

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi venkatasuresh_g ,

 

I want to acknowledge valuable input provided by tharunkumarRTK . The ISFILTERED function and the ISINSCOPE function are very helpful for the handling of hierarchical structures. Did the blog link provided by tharunkumarRTK  help you with your problem?  If solved, please mark the helpful answer as a solution this will help more people, if not please point it out.

 

Best Regards,

Neeko Tang