How to exclude latest month from variable?

[ramcena306]

Hi All,

PFA variable, I have a variable which shows 24M (Months)stock values.

how to adjust this variable to exclude the latest month?

stalwar1‌loveisfail‌sureshqv‌jontydkpi‌arvind1494‌kush141087‌

[Chanty4u · Accepted solution]

add this into your variable

Month -= {"$(=Date(MonthStart(Today()), 'Format'))"}

[ramcena306]

hi Chanty, Thanks for the Quick response, But, it's not working for me.

when I use this variable in a chart Expression it's showing 'No data to Display'

[ramcena306]

Otherwise, I want to create a new variable to get the stock values for the latest month by using this variable.

How can we do this?

[PrashantSangle]

are you using alternate state??

why you required scope resolution operator in your expression?

Regards,

[shiveshsingh]

=Sum({<Year = {"$=(max(year))"} , Month = {"$=(Date(Max(Month),'MMM'))"} >}Data)

You can use this to get last month sales

[ramcena306]

Hi Prashant,

Yes we are using Alternate state.

Actually I have to show stock values upto  completed months only,

for that, if I create a second variable  or an expression to get the stock values for the latest month and then I will  substract this value from the result of first variable. Then I will get the required Output.(Because the attached variable giving current month stock values also)

[ramcena306]

Hi Shivesh Singh,

This is not my requirement.

[shiveshsingh]

You can put this in variable, you wrote there to get lastmonth sales.right?

[ramcena306]

Hi Shivesh Singh,

Not Last month, to get latest month.