Calculated dimension

[nareshthavidishetty]

Hi,

I have used the below logic as calculated dimension. But it gives nothing.

Logic: =if(Aggr(sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales) <0,Invoice #),Loc)

Here i need to show only the invoice # if sum (sales) < 0 as per the above condition.

Thanks..

[MK_QSL]

=Aggr(

     If(SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) <0,Invoice #),Loc)

Updated:

=Aggr(If(SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) <0,[Invoice #]),Loc)

[sunny_talwar]

Not entirely sure, but may be we need Invoice # in the Aggr() also unless there is a one to one relation between invoice and location.

=Aggr(If(Sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) <0,[Invoice #]), Loc, [Invoice #])