set analysis error

[#1]

Hi,

i have an issue with set expression the following is expression

if(Desc2='Gross Profit',(sum({<vc_gl_code_L1={'4'} , YEAR={$(VMaxYear)}>} DEBITAMT-CRDTAMNT)*Flag_Sales

-

(sum({<vc_gl_code_L1={5},YEAR={$(VMaxYear)}>}DEBITAMT-CRDTAMNT))

the above expression it displaying only first expression  value that means after '-' operator expression  value is not considering.

[Anonymous]

Braces are incorrect. CAn you please explain what you are trying to here??

[tresesco]

May be you need to add one more parenthesis like.

if(Desc2='Gross Profit',(sum({<vc_gl_code_L1={'4'} , YEAR={$(VMaxYear)}>} DEBITAMT-CRDTAMNT)*Flag_Sales

-

(sum({<vc_gl_code_L1={5},YEAR={$(VMaxYear)}>}DEBITAMT-CRDTAMNT)) )

[Anil_Babu_Samineni]

May be parenthesis missing on end

[#5 · Accepted solution]

Thanks to all

if(Desc2='Gross Profit',(sum({<vc_gl_code_L1={'4'} , YEAR={$(VMaxYear)}>} DEBITAMT-CRDTAMNT)*Flag_Sales

-

(sum({<vc_gl_code_L1={5},YEAR={$(VMaxYear)}>}DEBITAMT-CRDTAMNT)) it is correct but am using variable of this expression