topic Past 7 Days Sales in App Development

Past 7 Days Sales

evansabres — Fri, 23 Aug 2019 19:04:21 GMT

I am looking to create an expression to produce a result of sales over the past 7 says for a particular buyer type

Date field is called 'TRANSDATE'

Sales field is called 'QTY'

Buyer Type Field is Called 'BUYERTYPE' and the particular value is 'ADULT'

I have the following which I believe should work, but not positive and I need to introduce the other qualifier of BUYERTYPE = ADULT. How do I need to structure this expression?

=SUM({<[TRANSDATE]={"$(=date(max([TRANDATE)-7"}>}QTY)

Re: Past 7 Days Sales

trdandamudi — Fri, 23 Aug 2019 19:15:04 GMT

Give a try on the below:

=SUM({<BUYERTYPE={'ADULT'},TRANSDATE={"$(=Date(Max(TRANDATE)-7))"}>}QTY)

Re: Past 7 Days Sales

neelamsaroha157 — Fri, 23 Aug 2019 19:24:22 GMT

Try this -

Sum({$<BUYERTYPE = {'ADULT'},TRANDATE={">=$(=(Max(TRANDATE)-7))<=$(=Max(TRANDATE))"}>}QTY)

[TRANSDATE]={"$(=date(max([TRANDATE)-7"} will give you data for only last 7th day not all 7 days.