Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to bring the month dimension into an existing App, however when I do my 'Conversion' expression is being affected.
This is the formula I am using for Conversion:
Sum({$ <[Fin Period] = {"<=$(VMaxFinPeriod)"} - {"<$(vMinFinPeriod)"},[Fin Year]=,[Fin Month]=, [Fin Week]=>}[Counter_Sale])
/
Sum({$ <[Fin Period] = {"<=$(vMaxFinPeriodInterviews)"} - {"<$(vMinFinPeriodIntervies)"},[Fin Year]=,[Fin Month]=, [Fin Week]=>}[Counter_Interviews])
This forumla works perfectly when I select on Fin Month in the list box. Does anyone know why when the month dimension is brought in the results change?
Thanks
Assuming you have another field called Month and want to include that in the expression (set analysis). If you want the selection in that field to be disregarded, you have to put Month=, in the set analysis. If you want the selection to filter data accordingly, there should not be anything such in the set.
Can you upload the sample application.