Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking for last 15 transaction values available in table how to write in set analysis?
if Sales=0, than i do not want to consider it in 15 days. Only 15 days where some sales<>0 and Sales = null.
thanks
Harleen
Could you share your data sample?
Hi Harleen,
you can use the date functions in sets you will get last 15 transactions.
other wise use transaction id and find-out last five transactions.
Regards
Sathish
Here is the data sample. in this sample you will not see any transaction on 10 and 11 may.
So last 15 day should not refelect 10 may and 11 may with 0 in chart.
I need a set statement for this
17/05/2017 | 15 |
16/05/2017 | 20 |
15/05/2017 | 25 |
14/05/2017 | 30 |
13/05/2017 | 35 |
12/05/2017 | 40 |
09/05/2017 | 0 |
08/05/2017 | 40 |
07/05/2017 | 25 |
06/05/2017 | 10 |
05/05/2017 | 10 |
04/05/2017 | 10 |
03/05/2017 | 10 |
02/05/2017 | 10 |
01/05/2017 | 10 |
hi,
are you using an master calendar? Otherwise May 10th and 11th will not be shown as a zero bar in your barchart.
To filter 9th of may too, you can use this formular:
Sum(
{$<
amount = {"<>0"}
>}
amount)
Here is the data sample. in this sample you will not see any transaction on 10 and 11 may.
So last 15 day should not refelect 10 may and 11 may with 0 in chart.
I need a set statement for this
17/05/2017 | 15 |
16/05/2017 | 20 |
15/05/2017 | 25 |
14/05/2017 | 30 |
13/05/2017 | 35 |
12/05/2017 | 40 |
09/05/2017 | 0 |
08/05/2017 | 40 |
07/05/2017 | 25 |
06/05/2017 | 10 |
05/05/2017 | 10 |
04/05/2017 | 10 |
03/05/2017 | 10 |
02/05/2017 | 10 |
01/05/2017 | 10 |