Variable with Parameters

[daanciorea]

Hi group!

I am using the follow variable

vFormula = Sum({<ID = {1,2}, $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13>}DATO)

I use the $1,..., $13 parameters to complete the variable with filters and fields that I need ignore.

If I complete all of $1, ..., $13 the variable work perfect. But, why not work good the variable when I don't complete all of $1, ..., $13?

In some objects I need complete all of $1, ..., $13 but in others don't and in this objects nothing is working. Do any can help me?

Thanks in advance.

Dan.

[isorinrusu · Accepted solution]

Hey,

An option is to use two variables.

So, your first variable would be vSumHours = sum({<$(vConcatFields($1,$2))>}Hrs.), and the second one is vConcatFields = $1=,$2= (etc.). When you call the variable, you would do something like $(vHoras(Cliente)) or $(vHoras(Cliente, Mes)), to ignore only Cliente or both Cliente and Mes.

See you tomorrow for a Special.

Regards,

Your boss.