Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I want a KPI with the number of records from the previous month.
So I'm trying to do the following:
=count({$<Date_Year={'$(=year(vMaxData))'}, Date_Month={"=$(=addmonths(month(vMaxData),-1))"}>} Canal)
vMaxData is a variable I created as max date. And it is working because I use it in other calculations.
this way is not giving any error but the counting is not right.
Can you help me?
Best Regards,
Miguel Cunha
Could be... very difficult to say without checking the file
ok thank you