Sum of variable in Set Analysis not working

[amijit_hazarika]

Hi All,

I am stuck in a situation where I am calculating sum of a variable and it's not working.

((sum({<[Partner AuditSubGeo] = {'Coastal'} ,[Partner Function] = {'Audit'}>}$(vFY18TotalBURevenue))

+

Sum({<[Partner AuditSubGeo] -= {'Coastal'} , [Engagement SubGeo] = {'Coastal'}>

+ <[Partner AuditSubGeo] = {'Coastal'} , [Partner Function] -= {'Audit'}>}$(vFY18TotalBURevenue)))

-

(sum({<[Partner AuditSubGeo] = {'Coastal'} ,[Engagement SubGeo] -= {'Coastal'}>}$(vFY18TotalBURevenue))))

Addition of 1st two set analysis and  then subtract the third with the resultant.

Below are the details;

vFY18TotalBURevenue  =  $(vManagedRevenue) - $(vOuttootherBURevenue)

vManagedRevenue = CYRevenue + PYRevenue

vOuttootherBURevenue  = OutRevenue

[olivierrobin]

hello

could you detail : it's not working

wrong result ? no result ?

did you try to check each part of your expression ?

[amijit_hazarika]

No, Individually also it is not working.

sum({<[Partner AuditSubGeo] = {'Coastal'} ,[Partner Function] = {'Audit'}>}$(vFY18TotalBURevenue

[olivierrobin]

and so what does 'not working' mean  ? no result ? wrong result ?

create a simple graph with your dimension and expressions

listboxes with the dimensions

select manually the combinations of values you use and see the result

[amijit_hazarika]

It's just giving me a - (dash)

[olivierrobin]

that means null

did you see null values in one of the columns of the sum ?

ig yes, replace + with rangesum() which treats nulls as 0