Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data set including following Columns
Transaction Date, Data Week, Qty
I want last data week total Qty
Thanks,
Vikas
Hi,
I do not want my filter with Transaction Date.
I want my filter at Month
In the expression above, I have nowhere used the date field as filter. Instead the date field used to get the latest month and the latest week. What could be the issue you see with the expression that may be not giving your expected output behavior?
The expression you have provided is working with the sample data set but not with my data
can Auto Calendar Month data be used in expression
It might not work within your actual data because of many possible reasons. You might have multiple years data. If so, you have to consider the year field as well or even only the date field. For multiple years data try like:
Sum({<Year={$(=Max(Year))}, [DataWeek] = {$(=Max({<[Transaction Date]={"$(=Max([Transaction Date]))"}>} DataWeek))}, Month = {$(=text(Month(Max([Transaction Date]))))}>} InvQty)
Otherwise, try to grab the logic why we used such expression and try to resolve yourself or prepare a sample with sample data with all possible scenario you might have in actual data - to let us work on that.
Seems working. Can you share real data where it is not working for you?
Hi,
I have created a unique column for calculation = KeyVal
I want my output as
Sum of Inv Qty @KeyVal= Max
Sum({<Keyval={$(=Max(Keyval))}>}InvQty)
Is giving me the desired output