Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a table with columns visit_date, sales_date, sales_amount. If I want to sum up the sales amount with sales date larger than visit date, can I use the formula:
SUM({<sales_date={>visit_date}>}sales_amount) ?
Thanks for help!
Hi,
try this:
SUM({<sales_date={">$(=max(visit_date))"}>}sales_amount)
I mean if there's a record with visit on Jan.1, sales on Jan.2, sum the amount. If another record with visit on Jan.4, sales on Jan.3, don't sum that amount.
Yes this expression will do the calculation like what you just described.
did you test it ?
try this and tell
SUM({<sales_date={">visit_date"}>}sales_amount)
SUM({<sales_date={">=visit_date"}>}sales_amount)