Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want my expression to calculate the sum of 2012 'RevDollars' and include the following conditions:
This is what I have so far, but I don't know how to include the null values:
sum({$<Year={2012},StartDate={'=<2008'}>}RevDollars)
Can anyone help me fix the syntax?
Try this and let me know:
sum({$<Year={2012},StartDate={'<=$(=2008)'},StartDate={'=null()'}>}RevDollars)
try StartDate={'=null()'} or StartDate= {''}
hope this helps
I couldn't get it to work. When I try the following two expressions, I only get the non-null values:
sum({$<Year={2012},StartDate={'<=$(=2008)'}>}RevDollars)+sum({$<Year={2012},StartDate={''}>}RevDollars)
sum({$<Year={2012},StartDate={'<=$(=2008)'}>}RevDollars)+sum({$<Year={2012},StartDate={'=null()'}>}RevDollars)
May be null values are discarded because of the filters or the model so it will never add values for null data.
Could you upload your qvw ??
Here is an example. Thank you for your help on this!
Hi,
Let try
=sum({$<Year={2012},StartDate={'<=$('2008')'}>} RevDollars) + sum({$-<StartDate=-{}>} RevDollars)
instead of
=sum({$<Year={2012},StartDate={'<=$('2008')'}>}RevDollars)+sum({$<Year={2012},StartDate={''}>}RevDollars)
Regards,
Sokkorn
I think the correct syntax should be:
sum({$<Year={2012},StartDate={'<=2008', "=len(StartDate)=0"}>}RevDollars)
I couldn't get those expressions to work (the nulls were still missing), so I ended up just adding a StartYearIndicator field in the script. I guess it's the long way around, but it worked. Thanks for your help everyone.