Parameterized variables (optional parameter)

[#1]

I want to create a parameterized variable to does something like this:

sum($1*$2)

however, I want the second parameter to be optional, so if $2 was not provided, it would just be sum($1).  I tried using an if(isnull($2)) with two separate functions, but that seems to evaluate the field passed in $2 and provided very wierd answers when i didn't pass a value in the second parameter.  Is there a QV function to test if a parameter was passed?

[Aurelien_Martinez · Accepted solution]

Hi,

You can try :

Sum($1*alt($2,1))

Best,

Aurélien