Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, l have to calculate sum of a field for today date how can i do this ? please answer.
Can you please help with the sample data and the actual requirement
Thanks,
Saloni
this is a sample expression in which i am counting the sum of a field for today's date i want the same value 'sum({<Date = {'$(=Date(today()))'} >} [field])' but without using today function if the today's value is null it shows the previous day value this is what i actually want.
@farzeenabbas Try sum({<Date={'$(Max(Date))'}>} [field])