Mike
My feedback
2 results found
-
2 votes
An error occurred while saving the comment Mike shared this idea · -
3 votes
An error occurred while saving the comment Mike commentedA currency column type based on regional settings would be great.
Also sub-request is to right align numeric values
Mike supported this idea ·
Currently using this formula which is nice but not nice enough...
With Current =
SUM{
Current
}:
WITH Target =
SUM{
IF Revised:
Revised
ELSE:
Baseline
}:
WITH Width = 10:
WITH Perc = ROUND(NUMBER((Current / Target) * Width, 0), 0):
IF Current & Target:
IF Current > 0 & Perc = 0:
CONCAT("", REPEAT("▄"; 1), "", "", REPEAT(" "; Width-1), "")
ELSE:
IF Perc > Width:
CONCAT("", REPEAT("▄"; Width), "", "", REPEAT("▀"; Perc-Width), "")
ELSE:
CONCAT("", REPEAT("▄"; Perc), "", "", REPEAT(" "; Width-Perc), "")