Variable declaration

[lakshmanvepuri]

Hi,

How to get the last 7 days in the reporting layer and Sum of the quantity.

Created variable : vLast7DaysFlag 

Def: If(REP_DATE >= Date(Floor(Now()) - 14) AND REP_DATE <= Date(Floor(Now()) - 1), 1, 0)

Used in the Reporting as:

=Sum('$(=vLast7DaysFlag)'> QTY)

Still I am not get the data in the table.

Please advice on this..

Thanks a lot.

regards

LK Vepuri

[vikasmahajan]

=Sum( {<($vLast7DaysFlag)>} QTY)

[sunny_talwar]

May be try this:

=Sum({<REP_DATE = {"$(='>=' & Date(Today() - 14, 'YourDateFormat') & '<=' & Date(Today() - 1, 'YourDateFormat'))"}>} QTY)

[sasiparupudi1]

Try

=Sum({<REP_DATE = {">=$(=max(REP_DATE)-14) <=$(=max(REP_DATE))"}>} QTY)

[jagan · Accepted solution]

Hi Lakshman,

Check this link for set analysis expressions for various time periods

For last 7 days

Last 10 Days Sales

Sum({<Year=, Quarter=, Month=, Week=, REP_DATE ={‘>=$(=Date(Today()-7))<=$(=Date(Today()-1))’}>} QTY)

Hope this helps you.

Regards,

jagan.