Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Any ideas
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!!!
Using Pivot table and Variable 2 as dimension in the pivot table