Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Anyone know a way to get this to work?
sum(
if([First Order Year]=
if(isnull(GetFieldSelections([Year Ordered])),
year(today()),
Max([Year Ordered])),
([Release Qty]*[Orderdtl Unit Price])))
I only want the sum to happen if the year ordered is equal to the max selected value.
So if they select 2012 it is 2012. If there select 2011 and 2012 it is still 2012.
try this
sum(if([First Order Year]=Max([Year Ordered]),[Release Qty]*[Orderdtl Unit Price])))
This returns an error in expression, with no value returned.
I guess I can just do it with set analysis. Not sure why I did not do that in the first place