Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I hope you may be able to assist with another small issue.
I have not used max Date before and always fixed data with set.
I have sorted my date import calendar and want to implement some dynamic date fields in tables.
when i use the following i am getting the max date returned
Date(Max([Voucher Date]))
I would like to use this with a basic sum of
Sum(HKD_Price)
But i am struggling to get a result when trying to glue the 2 together
Can you assist with this?
Thank you in advance
Daniel
Try like:
Sum({<[Voucher Date]={'$(=Date(Max([Voucher Date])))'}>} HKD_Price)
Try like:
Sum({<[Voucher Date]={'$(=Date(Max([Voucher Date])))'}>} HKD_Price)
Hey,
Thanks so much, giving this a try now and will reply shortly.
Daniel
HI,
Thanks again,
had some issue with the Voucher date but the syntax is perfect with Year instead.
This is great and gives me something to work with.
Thank you so much
Daniel