Set Analysis with Today() expression

[#1]

Hi guys,

i'm looking for some support.. I'm using this field:

- [Data Stat]= Date (DD/MM/YYYY)

- [Minuti]= it's a number used for the final sum

I'm implementing the set analysis in order to sum all the [Minuti] without using a filter pane in the visualization sheet.

The formula is:

Sum($<[Data Stat]={Today()}<}[Minuti])

But the today function doesn't work and it continues to give me error, can you help me?

Jack

[sunny_talwar]

What is the format of ReportDateEnd? Is it DD/MM/YYYY? Also look here for help with dates in set analysis

Dates in Set Analysis

[toddbuss]

Thanks.  I had to format my dates in the Data Load Editor.  The formula you provided works.