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

     

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.