Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem, I have a table with a legal size of year and quarter, I need to count the values for the corresponding period
I have two variables
The problem is when I put the variable x in the set analysis, this does not give me any results, next place the formula with a value written to validate that if the data exists, please help me, thanks
Hi, maybe that helps:
4.5.3 Using a variable storing integer members
With integer keys, you need to enclose the variable name between double quotes:
{<TIME_KEY = {"<$(vFirstPeriod)"}>}
Or {<TIME_KEY = {"<$(=vFirstPeriod)"}>}
The periods between two dates:
{<TIME_KEY = {">$(vFirstPeriod) <$(=vLastPeriod)"} >}
May be try by adding an equal sign within your dollar sign expansion and use Single or Double quotes
Count({<Periodo = {"$(=vPeriodoSet)"}>} @Id_Recurso)
Try double quotes but still not working, thanks
Try double quotes and the equal sign but still not working, thanks
My bad, try with vMaxPeriodo
Count({<Periodo = {"$(=vMaxPeriodo)"}>} @Id_Recurso)
Thanks Sunny but still not working,
If I put the variable with double quotes and the equal sign, this does not throw me nigun value
Would you be able to share your qvf to take a look at this?
Sure, what I want is to count the resources dynamically according to the dimension, if it is only the year of the last month of the year, if it is only quarter of the last month of the quarter and if it is monthly for each month, thank you very much
Like that?