conditional sum

[#1]

hello

i have a table like this:

id	d Day	Sales
1	1	50
2	1	100
3	2	20
4	2	50
5	3	300
6	3	20

i want to show the user sum of sales for the days befor than the day number he give as an input, i wrote it but it doesn't work :

Sum ({ <[Sales]={">=0"} ,  [d Day]={"$(<=CD)"}>}[Sales])

any one knows what is the problem?

thank you

azizi

[#2]

no it doesn't work

[#3]

no it doesn't work

[ashfaq_haseeb]

Hi,

Can you attached your sample file.

Regards

ASHFAQ

[#5]

thank all! specially Jonathan.

[d Day]={"<=$(=CD)"}

[jagan]

Hi,

This should definitely work, if not attach your file

Sum ({ <[d Day]={'<=$(=CD)'}>}[Sales])

Regards,

Jagan.