Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have two variables:
let vTest2 = max(month_ID)
let vTest = fieldname (numeric,1,2,3,4 ...12)
in TextBox, this works: $(vTest2)-$(vTest)
but in set Analysis no
=num(Count({$<month_ID ={"=$(=month_ID)- $(vTest)"}>}distinct customer_id),'#.##0')
i want to deduct both variables, how should i do this?
thanks
felipe
try like this:
num(Count({$<month_Id={"=max(month_Id)-$(vTest)"}>}distinct customer_id),'#.##0')
no it did not work, thanks