I am having two list boxes called period 1 and Period 2. All I need to show the delta values between them. So when user selects two period I will calculate the delta values as per below expression
num((if(sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])
-
sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD])
<0,
'($'&num(sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])
-
sum({<Flag1={3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD]))*-1&')',
sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])
-
sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD])))/10000000,'###.##')
However it showing "-" values in the expression. Kindly let me know what is the issue in formatting
