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

[ashfaq_haseeb]

Hi,

Your request is not clear.

Can you explain what is the output you expect here.

Regards

ASHFAQ

[jonathandienst · Accepted solution]

Hi

What is CD? You might need [d Day]={"<=$(=CD)"}

[#4]

sorry, the syntax i have wrote is this:

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

and CD is an input value. i want just the sum of sales that are before than the day that user gives me as an input(CD).

[#5]

sorry, the syntax i have wrote is this:

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

and CD is an input value. i want just the sum of sales that are before than the day that user gives me as an input(CD).

[ashfaq_haseeb]

Hi,

Try below

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

Regards

ASHFAQ

[jagan]

Hi,

Try like this

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

OR

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

Regards,

Jagan.

[#8]

hi Ashfagh.

if the user give 3 as input i want to have sum of sales with [d Day]=1,2,3   and not just for [d Day]=2

i mean all the days before the day he gave as CD.

[jagan]

Hi,

Then try this

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

Regars,

Jagan.

[ashfaq_haseeb]

Try below

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