Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Sum({<[Date of AR Run] = {"$(=Date(Max([Date of AR Run]), 'M/D/YYYY'))"}>} [Total IB])
Try this
Sum({<[Date of AR Run] = {"$(=Max([Date of AR Run]))"}>} [Total IB])
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
I tried both, and the the result is Zero now...
What is your date field format?
Try this
Sum({<[Date of AR Run] = {"$(=Date(Max([Date of AR Run]), 'M/D/YYYY'))"}>} [Total IB])
Thanks it worked!