Forum Discussion

Mamtas's avatar
Mamtas
Frequent Visitor
2 years ago
Solved

dividing by unique values. Do not use sum or count

I have these 2 tables YTD and Budgets. I need to create a measure in YTD, where it sum the Booked session as per centre , divide that by number of days and whatever the result is, Divide that by staf...
Need Help
  • Mamtas's avatar
    Mamtas
    2 years ago

    Hi Ryan,  First of all , thanks so much for your response.  Even after everything, i was not able to get the formulas to work for every centre.  

    Finally , i found the solution, by just changing the cross filter direction (as below) to 'Both' in relations.

     

    Thanks again for your help

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

that's what I get for alfi as well. I used the same logic as you mentioned

 

Mamtas's avatar
Mamtas
Frequent Visitor
2 years ago

Which one, 

First way or second ?

    • Mamtas's avatar
      Mamtas
      Frequent Visitor
      2 years ago

      Thanks mate, it works just like mine. i.e. works for some centres, but others giving wrong calculation.  That's the reason i tried lookup function, but that didnt work either.

       

      sometime Excel seems like a much better option.  At least you can see the calculation steps and see why and where is the mistake.

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        2 years ago

        then pls update the sample data or provide the output for other center.

        So far, I can't figure out the mistake. We need more info.