- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 09:38 AM
Hello, maybe this is not even possible, but if it is, what would be the proper syntax for this ?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 09:55 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 09:50 AM
just use this "" for the else portion.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 09:53 AM
hmm, still says invalid

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 09:55 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 09:57 AM
Thank you!!! that worked
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2023 10:08 AM
Hey @dpnetwork!
Here's your original formula:
IF(
VALUE({Total Rate 6})) > 0,
VALUE({Total Rate 6}),
Blank()
)
The first VALUE() function has a trailing open parentheses hanging on the end of it. The second syntax violation is the "Blank()" function. Whenever you invoke a function, you'll want to be sure to capitalize the function.
Here are a few syntax valid versions and permutations of your formula:
IF(
VALUE({Total Rate 6}),
VALUE({Total Rate 6})
)
IF(
{Total Rate 6},
{Total Rate 6}
)
IF(
{Total Rate 6},
{Total Rate 6},
""
)
I have historically found that the BLANK() function isn't always predictable. It generally doesn't have much usage in practice besides maybe making beefier formulas a bit more readable, but even then, they can make debugging a large formula rather difficult at times.
