Expression

[nareshthavidishetty]

Hi ,

I have used the below logic as calculated dimension . Based on the highlighted condition

Here i need to get the Inovice_num only for one day ie.,if Date= varMaxDate i need to show only those invoice numbers.

Logic: =Aggr(If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0),Inovice_num),Loc,APA0TX,Inovice_num)

Thanks..

[sdmech81]

Try to put this:

SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales)

in variable and then pass that in expression above and try .

Else send the application by dong limited load here.

Sachin

[sunny_talwar]

Does you chart have more than one dimension? Is Loc and APA0TX are dimensions also?

Also, what is the issue you are running into? Would you be able to share a sample?

[nareshthavidishetty]

Hi,

This isan calculated dimension i don't need sum(sales)

Here condition is

If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0) then show only those invoice numbers.

In the below logic i need to include one more condition to get only invoice #'s when date = varMaxDate.

Finally two conditions.

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

Thanks..

[nareshthavidishetty]

Hi,

Loc and APA0TX were dimensions.

Thanks..

[sunny_talwar]

Response to just one of the questions? How about other things I asked

[nareshthavidishetty]

Hi,

Dimensions: Loc ,APA0TX and calculated dimension.

calculated dimension:

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

Here  the condition is

If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0) then show only those invoice numbers.

The final condition might be

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

then show only those invoice #'s.

Thanks..

[nareshthavidishetty]

Hi,

Please provide the updated query.

Thanks..

[sunny_talwar]

Can you try this:

=Aggr(If(Sum({<Date = {'$(=varMaxDate)'}, flag = {'eSign'}, Category = {'Not Complete'}>} Sales) > 0, Inovice_num), Loc, APA0TX, Inovice_num)

[nareshthavidishetty]

Hi,

I need condition like below.

=if(Date=$(varMaxDate),Aggr(If((SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) > 0),NEW),Loc,APA0TX,NEW),NEW)

Thanks..