Does anyone know of a way to calculate percentage in the formula of a dataset item?
Dataset is:
1: Target - Number
2: Total Orders - Number
3 % Take-Up - Formula (% Of Total Orders from Target)
So if the target is 100, total orders is 50, the Take-Up column would automatically calculate at 50%.
Is this possible?
Thanks!
Rich
Yup.
Columns:
formula in take up
((total)*100)/target
Appearance tab in ticker
[target|190] | [total|191] - [take up|192]%
Result with some example values:
Well actually the formula should probably be:
ROUND(((total)*100)/target, 2)
as it will look better this way
Hope that helps.
Thanks! Very nearly there!
Is there any way I can add the % symbol inside the formula? I’m not using a ticker widget, I’m using a dataset one.
I’ve tried using: CONCAT(ROUND(((total)*100)/target, 1)),(’%’)
But it only returns % as the result.
Thanks,
Rich
CONCAT(ROUND(((total)*100)/target, 2), '%')
that should work.
Alternatively, I’m an idiot and forgot to set the column for take-up to Formula instead of Value 
That works perfectly! Thanks!
Rich
Ok, you got me worried there for a second 
I’m glad that works for you.
Only have one more issue 
The actual column names have spaces (so they show correctly in the dataset headers). If I add a space into the column name, it breaks the whole dataset:
CONCAT(ROUND(((Total Orders)*100)/Target, 2), ‘%’)
If “Total Oders” has a space, the dataset goes haywire until I delete that formula column
Right, you will want to put your column name between ` characters (ie backticks)
so no ’ ’ but `and it will work ie:
CONCAT(ROUND(((`total orders`)*100)/target, 2), '%')
Aha! Well, you are just a fantastic person and deserve some form of frosted beverage.
Thanks!
Rich
Is it possible to do conditional formatting, say color a column/cell if below 50% or something similar?
I am trying to replicate exactly as the same as @Zebwen posted with an attendance take up target for an event:
And don’t get the formula pulling through - any ideas?
Cheers
Dean
