Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i got a question, i am bit struggling with following issue, my data do look like:
test:
load * Inline [
MyData, Turnover
28.05.2021, 9
01.06.2021, 1
05.06.2021, 2
12.06.2021, 3
14.06.2021, 4
15.06.2021, 5
16.06.2021, 6
17.06.2021, 7
01.07.2021, 8
];
my issue is, how can i show the data of curren month but until today:
my expeceted output is: Sum(Turnover) = 10 , i am using this expression:
Sum({<Month = {"$(=Month(Today()))"}>}Turnover), but i receive the whole Turnover.
Does anybody have any idea how to rectify this issue?
Thanks a lot
Bek
Hi
Try like below
Sum({<MyData = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Turnover)
Hi
Try like below
Sum({<MyData = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Turnover)
Hi Mayil Vahanan R,
thanks a lot for your valuable time and your help