topic Re: An issue with a variable with parameter in App Development

An issue with a variable with parameter

Peony — Sat, 15 Mar 2025 21:21:24 GMT

Hi all. Please, could anyone give a piece of advice regarding an issue described below.

I created a variable with parameter v_Total_Dollar_Sales = Sum({<$1>} Dollar_Sales).
Also, I created a variable with list of fields that should be applied to $1 parameter v_Chicken_Dim_Total_Exclude = '%Chicken_Brand=, %Chicken_Segment=, %Chicken_Retailer=, %Chicken_Subcategory='
But when I applied it only %Chicken_Brand appeared in set analysis. Why is it so?

=$(v_Total_Dollar_Sales($(v_Chicken_Dim_Total_Exclude)))

Re: An issue with a variable with parameter

ramchalla — Sun, 16 Mar 2025 05:28:32 GMT

Hi Peony,

you need to prefix = to the definition of the variable.

Variable Name: v_Chicken_Dim_Total_Exclude

Variable definition ='%Chicken_Brand=, %Chicken_Segment=, %Chicken_Retailer=, %Chicken_Subcategory='

Re: An issue with a variable with parameter

marcus_sommer — Mon, 17 Mar 2025 11:53:07 GMT

Each comma within a variable-value will be treated as parameter-delimiter. There is no way to mask them but of course (quite ugly) workarounds to replace the commas in the creation as well within the call again.

Much better is to avoid the comma-stuff itself by dividing the content into n ones and/or to use a comma-free syntax - this may look like:

v: sum({ < $1, $2 >} Value)
$(v(a =, b =))

v: sum({ $1} Value)
$(v(< a = {(x|y|z)} > * < b = {(1|2|3)} >))

Re: An issue with a variable with parameter

Peony — Thu, 20 Mar 2025 14:59:01 GMT

@ramchalla thank you!

Re: An issue with a variable with parameter

Peony — Thu, 20 Mar 2025 14:59:40 GMT

@marcus_sommer interesting idea. thank you for this hint