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...
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