Alternate way to approach this situation

[#1]

Hello Friends

I have a scenario

I want to capture values in a variable and then use that variable in my set analysis.

Below is the scenario

Currently I have a variable DateToSubscribe which holds all possible values of [Last Subscribed Days]

Currently it uses p() function to hold the values

Requirement: My requirement is if DateToSubscribe=6  then I want 0,1,2,3,4,5,6 as the values to return (set analysis preferred)

Regards

Syed

[jonathandienst]

Not sure if I am understanding your requirement, but perhaps something like:

=Sum({<[Last Subscribed Days] = {"<=$(=Max([Last Subscribed Days]))"}>} ....)