If you just want to show the last data point value, you can use a conditional formatting of the data point value, maybe like shown here by John:
If you want to format the text in chart in a more complex way or show the value in a different chart object (which should be equivalent to your problem), you could try restructuring your formula:
if RETURN value is constant for all dates, your expression could maybe transformed into something like this:
= FirstSortedValue($(vAmt), Date) * pow((1+[Return]),count(Date))
Depending on your data model and requirements, something like this could work or maybe won't work. It would be helpful if you explain your other fields and the variable $(vAmt) a bit more. At best, you could attach a small sample app to your posting that demonstrate your issue.
Hope this helps,
Thanks for your help, below are the fields and variables involve:
[Return]=return of fund or index or stock
vStartDate=variable from input box from user
vAmt=variable from input box from user for initial investment
Hopefully that helps clarified the fields.
So vStartDate and vAmt are constant, not depending on your dimension, right?
And Return? Do you select one value, like from a list of percentages 1%,2%,3%...?
If Return is also independent from Date, I think you probably could use something like
=$(vAmt)*Pow((1+[Return]), count(distinct Date) )
which should be no different from a compound interest calculation. But maybe I've misunderstood your setting completely.