Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Give a try on the below:
=SUM({<BUYERTYPE={'ADULT'},TRANSDATE={"$(=Date(Max(TRANDATE)-7))"}>}QTY)
Give a try on the below:
=SUM({<BUYERTYPE={'ADULT'},TRANSDATE={"$(=Date(Max(TRANDATE)-7))"}>}QTY)
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.