Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a closing stock expression, save that it into variable and use that variable into chart but it showing same value for all the dimension without any selection when i select a particular dimension it is changing..
Expression
=sum({<PostingMonth=,PostingYear=,Period=,PostingDate={"<=$(vInvDate)"}>}Quantity)
In chart i use variable like this
$(vClosingStock)
Here i am attaching a screen shot please provide any suggestion to me
Thanks in advance
Sirajahamed S
Hi sundarakumar
It is working thanks
when i remove '=' in the expression overview it is working now..
Thanks
try aggr($(vClosingStock),PostingYear) or aggr($(vClosingStock),BudgetCenter)
Hi Siraj,
Please remove the "=" sign in the variable overview where u have created the variable..
Then it will work fine.
As u have put = in the variable overview, it is calculating without considering dimension in the chart,
it will work fine if u remove it...
Hope it helps.
-Sundar
Use aggr()
Hi Sivaraj seeman
thanks for your reply..
that expression also not working it showing the same...
Hi sundarakumar
It is working thanks
when i remove '=' in the expression overview it is working now..
Thanks
Hi,
Thanks lot
can you post your sample apps?
Hi Siraj,
Please close the thread, you can do it be marking the correct answer.
Thanks.
-Sundar
Make sure your Posting Date and the variable date have same forat try to use num(PostingDate) in backend and use it
here in variable vInvDate also date in number format
try this way
=sum({<PostingMonth=,PostingYear=,Period=,numPostingDate={'<=$(=vInvDate)'}>}Quantity)
in chart you write ='$(=vClosingStock)'
hope it helps