using variable in expression

[sakshikaul]

Hi

I am having an internal table as follows

InlinetableLastYear:
LOAD *
INLINE [

lastDate,event

10/12/2017,Diwali
10/10/2017,Durga Pooja

];

Here in the image below I have two variables

1st variable

1.compday(comparison no of days ) which is user defined variable which means when  the user will enter no. of days which he wants say 6 so the corresponding formula should be calculated as mentioned in variable 2

2. DaysOfcomp is a second variable which will calculate following formula

=(SoldDate)-compday

eg =(20171012)-6

it gives value as 43014

if taken this variable DaysOfComp in text box it will give value as 10/6/2017

now I am getting following values in charts for the expression given below

=Sum({<Sold_Date = {"=$(=Date(date(Sold_Date) - $(compday)))"}>} [inv value])

now I simply want the 2nd variable used here  DaysOfComp should be used in expression

if taken this variable DaysOfComp in text box it will give value as 10/6/2017

so I want to use variable DaysOfComp in the expression. I want to have sales for the date 10/6/2017 to be depicted in chart

Please help !!