python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Custom functions in Excel error evaluating false part of IIF
Below is my custom functions in Excel.
Function DISCOUNT(c1, r1, k1)
Dim res
res = Application.WorksheetFunction.VLookup(c1, r1, 2, False)
DISCOUNT = IIf(Not (IsError(res)), res, k1)
En...

Bishan
Votes: 0
Answers: 1
Checking Function Parameter Postgres
i'm trying to find the fastest way to check whether my postgres function parameter is null or empty.
my current function looks like:
CREATE OR REPLATE FUNCTON update_seller_detail(seller_id int,
sell...

Yohanes Lim
Votes: 0
Answers: 1
Issues running PySpark UDF with Databricks Connect
I'm having problems running my PySpark UDFs in a distributed way, e.g. via Databricks Connect.
For example:
import pyspark.sql.functions as f
class MyClass(object):
def __init__(self, number_stri...

Kasia Kulma
Votes: 0
Answers: 0
How to return 0 if null from UDF in Snowflake
I am writing user defined functions in Snowflake and doing some SELECT in the functions. I need to return 0 if select returns NULL.
In the below example if there is no rid available from tableA, funct...
Raj
Votes: 0
Answers: 1