Variable not working as expected

[santharubban]

Hi All,

I have 2 variable one variable definition  as below

Variable 1: 

Num((($(='%Lw_AU_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_EDC_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_VSA_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_DAT_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_DS_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_TASE_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_VD_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_IE_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_VNVH_SQ_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_Weight_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_PQ_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_QHC_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_ONA_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_Safety_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_PFER_'&Concat(DISTINCT InputField, ','))) +
($(='%Lw_PRD_'&Concat(DISTINCT InputField, ',')))), '#,##0.00;(#,##0.00)')

and I am call this variable 1  in the second variable as below

($(=Concat(DISTINCT InputField, ',')) + $(Variable 1))

I am not able get variable 1 value in Variable 2

If i use  ($(=Concat(DISTINCT InputField, ',')) + $(=$(Variable 1))) , I am get value but its not carrying sign (-)(+) its always positive value. 

Can anyone help me.

[santharubban]

Any ideas 

[santharubban]

Please any help on above question

[Marcos_rv]

Can you show us a table with the expected input and output info ??? and that's in the script ?? I do not understand what you want to do. Regards!!!

[santharubban]

Using Pivot table and Variable 2 as dimension in the pivot table