
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 30, 2019 07:10 AM
This is probably a stupid question, but why is my result not a number in the following If statement?
IF({Course Order}>0,{Cost-1st Attendee}+{Cost-2nd Attendee}+{Cost-Additional Attendees}, “”)
It actually works, but I can’t format it, and the Summary fields don’t work. When I click on the Formatting tab, I get the following message.
“Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.”
How can I get the results to be formatted as currency (I assume that fix will make the Summary fields work)?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 30, 2019 07:34 AM
OK, as I said, stupid question. Replaced the double quotes (that dictate text) with a zero, and all is well with the world.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 28, 2022 07:23 AM
Unfortunately that doesn’t work for dates. I wonder if there is a “null date” concept that could be used for blank cells but still allow the field to be formatted as a date
