Help

Re: IF Statement syntax

Solved
Jump to Solution
1940 0
cancel
Showing results for 
Search instead for 
Did you mean: 
dpnetwork
4 - Data Explorer
4 - Data Explorer

Hello, maybe this is not even possible, but if it is, what would be the proper syntax for this ?

IF(VALUE({Total Rate 6})) >0, VALUE({Total Rate 6}), Blank()
 
This field is showing the data of another column called "Total Rate 6", but i want it to be blank if the amount is 0(zero)
1 Solution

Accepted Solutions
Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast
*you have a parenthisis at the wrong spot, that this snippet:
 
IF(VALUE({Total Rate 6}) >0, VALUE({Total Rate 6}), "")

See Solution in Thread

5 Replies 5
Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast

just use this "" for the else portion.

dpnetwork
4 - Data Explorer
4 - Data Explorer

hmm, still says invalid

Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast
*you have a parenthisis at the wrong spot, that this snippet:
 
IF(VALUE({Total Rate 6}) >0, VALUE({Total Rate 6}), "")
dpnetwork
4 - Data Explorer
4 - Data Explorer

Thank you!!! that worked

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.