Need help to write an expression ?

[ashmitp869]

Hi All,

Please kindly see the image attached.

The Non User calculation is done in second chart -

if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0)

so , if no policy sold then non user is [open user] - [no.of policy sold]

the second chart is working correctly as there is dimension Dealership in the chart .

But , for the first chart ,

there is no dealership dimension . Thus the Non user is not working correctly .

if I used the expression -

if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0) the result is showing 0 as there are not breaks down in dealership dimension.

Please assist me in writing the expression.

Many Thanks,

[kaushiknsolanki]

Try this.

Sum( Aggr(if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0),Delearship))

Regards,

Kaushik Solanki

[shiveshsingh]

Hi

plz try this in calculated dimension

Aggr(if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0),Delearship)