Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to sum a value of a column of data using the date with a format of MM/DD/YYYY. I am using the following expression and having no luck.
=Sum({$<[POS Date]={"$(=addyears(Date(Max([POS Date]),'MM/DD/YYYY'),-1))"}>}[POS Adjusted Fair Value])
Any help would be appreciated.
Can you try this one for your second expression??
=Sum({$<[POS Date]={"$(=Num(AddYears(Date(Max([POS Date])), -1)))"}>}[POS Adjusted Fair Value])
That did not work.
Can you share a sample application to look at?
Best,
Sunny
Sunny,
Let me play around with it a bit and see if I can get it to work. Thanks for your assistance.
Not a problem, I wish I was more helpful. Let me know if you don't find any way to fix it.
Best,
Sunny
Thanks, you were very helpful. Just need to play around with it a bit.
Sunny,
Thanks, I was able to get it to work with a little bit of effort. Your answer was correct.
Awesome! I am glad we were finally able to figure it out.
Best,
Sunny