Forum Discussion

KBVelasco's avatar
KBVelasco
Frequent Visitor
6 years ago
Solved

Display remaining percentage

What is the easiest way to display the remaining percentage of the following measure (ie. show 8% instead of 92%)?  Everything I've tried either returns the wrong value or applies a value to rows tha...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    KBVelasco and make sure format is changed to % 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

KBVelasco and make sure format is changed to % 

KBVelasco's avatar
KBVelasco
Frequent Visitor
6 years ago

This is what I ended up with.  Everything looks like it's working as it should.  Thank you!

 

Budget Remaining = IF([User Budget]>0, 1 - [Budget Used %], [Blank])