Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am stuck here for calculating data
From last 24 months have to check data with first 6 months and
for last 6 months based on a date column in format(YYYYMMDD) to first 18 months.
Can you anyone please suggest.
here it is,
you have the data, the expression, the output, enjoy
where is output
Can't you see this on the app I gave you ???
i did not see app attached here
here it is
here it is attached one more time
In the app you sent have only sample date and data which i provided. No Expression is there for 6 months and 18 months data. Can you please add that in app and resend please
yeah, i see it now.
But In the app you sent have only sample date and data which i provided. No Expression is there for 6 months and 18 months data. Can you please add that in app and resend please
and also in screenshot, you provided 18 months as last 18 months but my request to get first 18 months in last 24 months
OK, open the app, take screen shots of what you can see on it (Tables, and expressions on the tables).
If you don't know how to attach screen shots here, here is my email: youssefbelloumtn@gmail.com
JUST SHOW ME WHAT YOU CAN SEE ON THE APP I SEND TO YOU
Thank you
Not able to attach screenshot now, but in app we have only 2 columns date and data
where i add date and data into sheet it gave as
date data
20160301 100
20160401 400
20160501 500
20160601
20160701
20160801
20160901
20161001
20161101
20161201
20170101
20170201
20170301
20170401
20170501
20170601
20170701
20170801
20170901
20171001
20171101
20171201
20180101
20180201
but i need an expression for last 6 months and first 18 moths in last 24 months. can you help here please