Set Analysis: Sum Bookmark Value with two between days

[muniyandi]

Hi Friends,

How to sum bookmark value and two between days using set analysis.

1. Ex: SUM({BM02 <SALESDATE={">=$(WEEKSTART(DATE))<=$(WEEKEND(DATE))"}>} SALESQTY)

As Same None Bookmark using is work

2. Ex: SUM({<SALESDATE={">=$(WEEKSTART(DATE))<=$(WEEKEND(DATE))"}>} SALESQTY)

With Regards,

V.Muni

[perumal_41 · Accepted solution]

Hi muni,

Muni Ur Expression is Wrong Please check thiis Expression

=SUM({BM02 <SaleDate={">=$(=weekstart(Date(DATE)))<=$(=weekend(Date(DATE))"}>} SalesAmount)

[muniyandi]

Thankx Perumal A.

You expression is correct.

We are using variable must use = ?

[perumal_41]

Hi,

when use function inside variable  u want to use '='  must.