Use condition inside Sum()

[Anonymous]

I want to display the savings value corresponding to a particular date using an expression.

I tried using the below expression but it's not working.

sum(

if(

date(TimeStamp#([processed_date],'YYYY-MM-DD hh:mm:ss.s'),'DD/MM/YYYY')))= date(TimeStamp#('2017-01-02 00:00:00.0','YYYY-MM-DD hh:mm:ss.s'),'DD/MM/YYYY'))),

[Savings],

0

))

can anyone help on this pls?

[stigchel]

If the time of the particular date is of no interest, I would suggest to floor (removing the time portion) the date before comparing. See also

Rounding Errors

[antoniotiman · Accepted solution]

Hi Faris,

try this

=sum(
if(
date(TimeStamp#([processed_date],'YYYY-MM-DD hh:mm:ss.f'),'DD/MM/YYYY')
= date(TimeStamp#('2017-01-02 00:00:00.0','YYYY-MM-DD hh:mm:ss.f'),'DD/MM/YYYY'),
[Savings],
0
))

Regards,

Antonio