Forum Discussion

aglpr's avatar
aglpr
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Dividing FIltered Value

Hello,   I tried to divide the value of one row to other calculated measure in other table. This the sample matrix below   I tried to calculate the success number (measure from other table)...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi aglpr 
    Nothing wrong. Your measure seems to be fine but the outcome of this division is a very small number that is rounded to zero. just change the format to percentage and increase the number of decimal places. Otherwise, double check and confirm which is the denominator and which is the numerator.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi aglpr 
Nothing wrong. Your measure seems to be fine but the outcome of this division is a very small number that is rounded to zero. just change the format to percentage and increase the number of decimal places. Otherwise, double check and confirm which is the denominator and which is the numerator.

aglpr's avatar
aglpr
Icon for Advocate II rankAdvocate II
4 years ago

Dear Tammer,

 

What a silly stupid mistake that I've made. I misplaced the numerator and the denominator.

 

Thank you so much for pointing it out. Feel so dumb right now

 

Thnak you once again!