Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
in my model, i have an expression as below
Count({$<ApplicantSubStatus={'A'} ,FromMonthYear= p(MonthYear)> } distinct App_ID)
when selection in the model is 2019 without Month or MonthYear it retrieves the accumulated value
when selecting MonthYear or Year value and Month value it retrieves the correct
how can i edit the expression that it will retrive only the correct population for every month and not the accumulated
attached examples
advanced thanks
What do your tables and relationships look like? Do you calculate FromMonthYear?