Webi Report - Null date
I have below senerio in Webi Reprot which is from SAP Cubes.
Client clearing date Amount
100 1/2/2009 100
103 28/2/2009 200
Now my Query is i want get the sum of value where Clearing date is Null and less than 28/2/2009
that means data of 101 & 102 customers that is 500.
I am using SAP Cubes so i have some limitations. to make Query level filters and prompts .
so i did take all data into report and calculated ..