Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All,
i am trying to dynamically change the header on my report dynamically based on selections from inside my QV App.
i have a list box, and attemptiing to have the header change based on sales.
GOALS: When no 'Sale Date' selection is made, to have the header say: "Sales for min(SaleDate) to max(SaleDate)"
When a "Sale Date" selection is made, to have the header say: "Sales for selected month"
Problems:
-For the 1st GOAL, i am having trouble adding the 'to max(SaleDate)' part of the formula. Need help with the syntax
-For the 2nd goal, when i select 2 months, i want both months to show up in the header..it should read "Sales for Sale Date selected month1 +selected month2 "
Current Syntax : =( 'Sales for ' & if([Sale Date] = [Sale Date], GetCurrentSelections([Sale Date]), MonthName(min([Sale Date])) ))
thanks!
How about something like:
=If(GetPossibleCount(Month) = 1,
'Sales for ' & Month,
'Sales from ' & Date(Min(Date)) & ' to ' & Date(Max(Date))
)
-- assumes that the Month field is dual month value and the date field is a QV numeric date value