Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a situation where i have to find out the values for current month of current year , current month of previous year.
for the current year the query was
COUNT(DISTINCT{<MON={'$(=max(MON))'},YR={'$(=max(YR))'}>}ID)
but i am getting the value as 0. Is there anything that i am missing. Please provide your feedback.
let's try replacing ' with ".
are you getting values for Max month and Maxyear?
Try to check by placing in Text box
I am not getting values for any of the condition. its a zero.
I did but Negative. Still the same value.
What is the format of month and year
Try to place Month in list box and
=Max(Month) as expression in Text Object