MichelleCoslet
7 years agoQrew Assistant Captain
formula using summary fields?
Am i able to create a formula that uses summary fields?
I have a summary field that shows the projects completion as a percent.
Here is what i have so far, but i keep getting an error.
Formula error -- Bad or missing arguments in function cal
Is it because the field is not a number or a text, but is a summary? I have tried both "case" and "if" as well as tried with and without quotations around the numbers.
The last line is meant to show the go to source icon if percent is equal to 0.
If([Percent Complete], "25","<img src=\"https://images.quickbase.com/si/16/504-spanner.png\">>";,
[Percent Complete], "50","<img src=\"https://images.quickbase.com/si/16/440-dollar-1.png\">>";,
[Percent Complete], "75","<img src=\"https://images.quickbase.com/si/16/211-check_all.png\">>";,
"<img src=\"https://images.quickbase.com/si/16/778-go_to_source.png\">>")
I have a summary field that shows the projects completion as a percent.
Here is what i have so far, but i keep getting an error.
Formula error -- Bad or missing arguments in function cal
Is it because the field is not a number or a text, but is a summary? I have tried both "case" and "if" as well as tried with and without quotations around the numbers.
The last line is meant to show the go to source icon if percent is equal to 0.
If([Percent Complete], "25","<img src=\"https://images.quickbase.com/si/16/504-spanner.png\">>";,
[Percent Complete], "50","<img src=\"https://images.quickbase.com/si/16/440-dollar-1.png\">>";,
[Percent Complete], "75","<img src=\"https://images.quickbase.com/si/16/211-check_all.png\">>";,
"<img src=\"https://images.quickbase.com/si/16/778-go_to_source.png\">>")