So I have one input showing a Budget-Amount and another showing Actual-Amount. I’m using the bubble progress bar and when the Actual-Amount is over the Budget-Amount I need it show the % over 100%. Like 110% or 200% Currently it just tops out at 100%. BTW, the number values converted to currency but I’m not sure that has an impact on the calculation?
2 Likes
Ok… I have the following: Input A Budget-Cost. Input B Actual-Cost. The formula I use is. Input B Actual-Cost value / Input A Budget-Cost Value. For example Input B Actual-Cost $400 / Input A Budget Cost $300 the Progress bar reads 1.33333333 I’ve tried a hundred ways to get this to read 133%. I must be overlooking something simple?
I have a site with a lot of formulas…
so I would say try this:
B Actual Cost value/Input A Budget Cost value * 100 :rounded to 0
You’re overlooking the rounded to part, which is why I think you’re getting what you are
1 Like
No joy…. I get 100%
What exactly are you trying to do?
What’s the scale of your progress bar?
Is this percentage that you want to display, exceeding 100%, the percentage that appears in the progress bar? Or a text element? Perhaps if it is the text that appears in the progress bar itself, it gets stuck at 100%.
Yes, @carlovsk.edits the text in the progress bar just doesn’t want to show any % over 100% as such. I’ve moved the this calc and still no luck. (New# - Old#) / Old# = X%. (400-300) / 300 formatted as % = 33% @senecadatabase suggested *100 rounded to 0. And I haven’t been able to make that work either?
Well…. I just read the Progress Bar Doc, and discovered its only designed to read 0-100% 
It’s always something.
There are a few alternatives: you can use another plugin, or create your progress bar with an HTML element as well.
Thanks @carlovsk.edits that’s kind of what I figured. I think I’ll just stick a janky-text “1” in front of it and call it good.
I caution us all to be aware of the difference between Simple and Simplistic.
You can place the progress bar in an align to parent group, and then place text on top of it. In the progress bar, leave the font color transparent, and in the text, enter the percentage. This should work, and it’s a simple solution too.
Thanks @carlovsk.edits I did something similar. Just that when the progress bar goes over 100 I hide it and show text elements with colored backgrounds etc. I’m just dismayed the progress doesn’t show % over 100.
I think this formula placed in a Text element gets me close enough both in terms of functionality and accuracy. I rounded to 3 and Multiplied by 100. Once the bubble Progress Element goes over 100 I simply hide it and show my own group containing containing the Text(s) and colored red. Feel free to suggest any improvements.
BTW. I haven’t tried to implement this directly to the bubble progress bar via conditional expression. I’ll try it later and followup. Thanks to all who replied and offered insight.