Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA variable, I have a variable which shows 24M (Months)stock values.
how to adjust this variable to exclude the latest month?
stalwar1loveisfailsureshqvjontydkpiarvind1494kush141087
add this into your variable
Month -= {"$(=Date(MonthStart(Today()), 'Format'))"}
add this into your variable
Month -= {"$(=Date(MonthStart(Today()), 'Format'))"}
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'
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?
are you using alternate state??
why you required scope resolution operator in your expression?
Regards,
=Sum({<Year = {"$=(max(year))"} , Month = {"$=(Date(Max(Month),'MMM'))"} >}Data)
You can use this to get last month sales
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)
Hi Shivesh Singh,
This is not my requirement.
You can put this in variable, you wrote there to get lastmonth sales.right?
Hi Shivesh Singh,
Not Last month, to get latest month.