I have an expression to build a pie chart that compares dates to sort the data. The expression to create the pie chart works fine, but when I try to use that same expression to build the color by expression, the color never changes.
Example:
=If((not isnull([SA Milestone Revised Date])) and (Date([SA Milestone Revised Date])) >= Today()
and isnull([SA Milestone Completed Date])
and
TimeStamp([SA Milestone Revised Date]) >= today()
and
Timestamp([SA Milestone Revised Date]) <= Today()+ $($(vMilestoneFilter))
, lightblue(), //f
If((not isnull([SA Milestone Initial Date]) and isnull([SA Milestone Revised Date])) and (Date([SA Milestone Initial Date])) >= Today()
and isnull([SA Milestone Completed Date])
and [SA TOTAL_REQUIRED_VALUE]>=$($(vDollar_Threshold))
and
TimeStamp([SA Milestone Initial Date]) >= today()
and
Timestamp([SA Milestone Initial Date]) <= Today() + $($(vMilestoneFilter))
, lightblue(), //f
If(not isnull([SA Milestone Revised Date]) and (Date([SA Milestone Revised Date]) < Today()
and isnull([SA Milestone Completed Date])
and [SA TOTAL_REQUIRED_VALUE]>=$($(vDollar_Threshold))
and $($(vMilestoneFilter)) = 7200
)
, Red(), //pd
If(not isnull([SA Milestone Revised Date]) and (Date([SA Milestone Revised Date]) < Today()
and not isnull([SA Milestone Completed Date]) and Date([SA Milestone Completed Date] > Date([SA Milestone Revised Date]))
and [SA TOTAL_REQUIRED_VALUE]>=$($(vDollar_Threshold))
and $($(vMilestoneFilter)) = 7200
)
, green(), //cl
If((isnull([SA Milestone Revised Date]) and not isnull([SA Milestone Initial Date]))
and (Date([SA Milestone Initial Date]) < Today() and isnull([SA Milestone Completed Date])
and [SA TOTAL_REQUIRED_VALUE]>=$($(vDollar_Threshold))
and $($(vMilestoneFilter)) = 7200
)
, Red(), //pd
If((isnull([SA Milestone Revised Date]) and not isnull([SA Milestone Initial Date]))
and (Date([SA Milestone Initial Date]) < Today() and Date([SA Milestone Completed Date]) > Date([SA Milestone Initial Date])
and [SA TOTAL_REQUIRED_VALUE]>=$($(vDollar_Threshold))
and $($(vMilestoneFilter)) = 7200
)
, green(), //cl
If(not isnull([SA Milestone Completed Date])
and $($(vMilestoneFilter)) = 7200
and [SA TOTAL_REQUIRED_VALUE]>=$($(vDollar_Threshold)), Yellow())))))))
