Current Aging Total Variable

[akuttler]

I need help to create a variable for the most current total AR IB Balance. I have the Expression below:

sum({<[Date of AR Run] = {'Max([Date of AR Run])'}>} [Total IB])

But the result is null.

Thanks.

[sunny_talwar]

Try this

Sum({<[Date of AR Run] = {"$(=Max([Date of AR Run]))"}>} [Total IB])

[jolivares]

Try to put :

sum({<[Date of AR Run] = {'Date(Max([Date of AR Run]))'}>} [Total IB])

With the same format MM/DD/YYYY for both dates

[akuttler]

I tried both, and the the result is Zero now...

[sunny_talwar]

What is your date field format?

[akuttler]

[sunny_talwar · Accepted solution]

Try this

Sum({<[Date of AR Run] = {"$(=Date(Max([Date of AR Run]), 'M/D/YYYY'))"}>} [Total IB])

[akuttler]

Thanks it worked!