Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to calculatethe quantity with day GR_Date is greater or equal to variable Last Month End Day.
"Last Month End Day" has been reached as variable.
How to correct following expression?
count({<GR_Date>={"$(Last Month End Day)"}>}distinct(GR_Number&[GR_Line No.]))
Try this
count({<GR_Date={">=$(=MonthEnd(AddMonths(Max(GR_Date), -1)))"}>} distinct GR_Number & GR_Line No.)
"Last Month End Day" has been reached as variable. Your expression does not work.
Can you attach full screen
Just wanted to see the results below in expression editor area
Dear @Chanty4u , could you please take a look at this issue? I would not get the correct answer.