Expression in variable not working

[Anonymous]

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

[sivarajs]

try aggr($(vClosingStock),PostingYear) or aggr($(vClosingStock),BudgetCenter)

[sundarakumar]

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

[sujeetsingh]

Use aggr()

[Anonymous]

Hi Sivaraj seeman

thanks for your reply..

that expression  also not working it showing the same...

[Anonymous · Accepted solution]

Hi sundarakumar

It is working thanks

when i remove '=' in the expression overview it is working now..

Thanks

[Anonymous]

Hi,

Thanks lot

[MK_QSL]

can you post your sample apps?

[sundarakumar]

Hi Siraj,

Please close the thread, you can do it be marking the correct answer.

Thanks.

-Sundar

[er_mohit]

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