Compare Data of Today to Yesterday

[#1]

Hey Guys, first post...

small question though, beginners one 🙂

I want to SUM the COST for a certain day, using the day i currently have... in other words, if i select the 2nd of july i want to sum the amount of the 1st, if i select the 1st i want to sum the 30/06 and so on...

I was sure it's going to be simple but im totally stuck!

I tried this with no luck: =sum({<Day=Date(Day-1)>} Cost)

(Day is my field of date)

Can you please help me?

thanks!

Zohar.

[jonathandienst · Accepted solution]

Zohar

I used this on your example and it seems to work correctly:

=Sum({<[Date]={"$(=Date(Max([Date])-1))"},TheYear=,TheMonth=,TheWeek=,TheDay=,Quarter=>} Cost)

See the attached where I have added this into your example.

Regards

Jonathan

[#3]

Yay!! Finally 🙂

I would love an explanation of what i did wrong or why this answer works... i tried everything... or so i though!

BTW, i can't open the file you sent to me, it tells me that my personal edition has exceeded the limit of opening other people's files, but i copied what you did and it worked... is there any way to go around the limit of files?

Thanks a lot!!!!!!

Sitting on this for days now!

Zohar.

[jonathandienst]

Zohar

You're welcome.

zoharpos wrote:

BTW, i can't open the file you sent to me, it tells me that my personal edition has exceeded the limit of opening other people's files, but i copied what you did and it worked... is there any way to go around the limit of files?

Afraid not, without buying a license to upgrade your personal edition.

Regards

Jonathan