I am creating a calculated field Max(Date) . This is then assigned to a parameter
My requirement is:
if [parameter named max date]=[Last day of current month] then
When new data gets added to the backend and I refresh the extracts, The calculated field is able to get the correct Max(Date) but it doesn't assign this value to the parameter automatically.(i need to do it manually). How to resolve this issue. I tried replacing the
if [parameter named max date]=[Last day of current month] then //logic
if [Max(Date)]=[Last day of current month] then//logic
but then it gives error saying cannot mix aggregate and non-aggregates.
You should be able to do this via a calculation, but it is difficult to help without a sample of what you are doing. Can you attach a packaged workbook (.twbx)? Please see Attaching a Packaged Workbook.