Expression is not working

[#1]

Hi,

Pls find the attached xls file along with dashboard, For Apple Product, I wanted to see Sales data from current month to future.

Not sure whats wrong in my expression: =IF([Product Cat]='Apple' and month(Date)>=Month(Today()), SUM(Sales),0)

I am trying to display data for Apple from Dec to future months

For Samsung whatever data is there.

I am using personal edition. Attached screenshot might help what I am expecting.

Appreciate your help.

Thanks,

[#2]

No Gupta,

requirement is to calculate monthly basis, If I run dashboard this month, I supposed to get from Dec onwards as it is a kind of forecasting.

For Apple, Nov month data is 264 and year is 2014. for Dec it is 640 and follows...

For Samsung, its a simple calculation.. it has to get whatever data is there.

Pls let me know if I am not clear.

Thanks,

[#3]

Oh, there was typo error, looks like correct and will get back to you if I need further help.

Thanks for the correction.

Thanks,

[#4]

hey madu,

see you are having three years 2014,2015 and 2104 i think in your table 2104 is miss spell,because data for 2014 nov+2104 nov for product apple is 264 that you are mentioned... see in the image below

i have replaced 2104 to 2014 then the table will look like below image

now clear your requirement,if you have any doubts

[lironbaram]

hi

ths is the correct expression

=sum(IF([Product Cat]='Apple' ,if( Date>=Today(), Sales,0),Sales))