Forum Discussion

timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago
Solved

Monthly Percentage

Hi all   I'm new to Power and have only done three of the tutorials so I apologise if the question has a simple answer!   How would I go about showing the total number of records / rows that read...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

timoneill84,

I am not clear about your requirement, could you please share expected result based on the dummy data you share?

Regards,
Lydia

timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago

sorry, so here is the dummy data again (i've changed the figures that need to be summed in table two):-

 

12345678      001234566     2      001234566 2       5 Door Hatchback

12345679      001234567     4      001234567 4       5 Door 4x4

12345673      001234569     7      001234569 7       3 Door 4x4

 

second table:-

 

5 Door Hatchback   10

5 Door 4x4              6

3 Door 4x4              5

 

formula would need to do 2 (as there are 2 4x4s) divided by 11 (6+5 as the sum for text criteria containing 4x4) x100 to get a percentage figure.

 

Hope that makes sense.

    • timoneill84's avatar
      timoneill84
      Frequent Visitor
      8 years ago

      Hi

       

      I'm just trying to modify the check formula which currently reads:-

       

      check = IF(ISERROR(SEARCH("4x4",Claims[Vehicle Type])),1,0)

       

      How do I get it to search for multiple text criteria instead of just 4x4? so say search for 4x4 OR apples and return 0 next to those rows?

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        timoneill84，

        This thread has been closed, please open a new thread about the new question.

        Regards,
        Lydia