Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table were I want the summation to only work when a records Month is in range.
My example below I hope illustrates my goal.
The Closed date column should only show a value for Dec 2013 since the opportunity was closed that month.
But instead it shows the value for each month. The Active column is the inverse were it should show For Oct-Nov.
Active
Sum({<Status_CRM = {"1"} >}dol_PV_YR1)
Closed:
Sum( {< Stage = {'>=8<=11'} >} dol_PV_YR1)
proposed: lost on this?
If( CloseDate = Max(CloseDate) , Sum( {< Stage = {'>=8<=11'} ,Stage_Gate=,Status_CRM=,Status= >} dol_PV_YR1)/1000 )
Have a look at the file I have attached. It should give you what you need.
Please post a .qvw
Preparing examples for Upload - Reduction and Data Scrambling
upload QVW file
Ok, I uploaded a QVW. Thanks
Have a look at the file I have attached. It should give you what you need.
Thanks Nicole! This is what I needed.