Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this expression:
=SUM({$<[CleanMonth]={'2017/01'}, [ProdType]={'129'}>} Net_Revenue_Value)
This works perfectly. When I try to add in a variable in its place, I return no results.
SUM({$<[CleanMonth]={$(vNextSalesPeriod)}, [ProdType]={'129'}>} Net_Revenue_Value)
vNextSalesPeriod is a value from a database table which returns 2017/01 and shows correctly when I reference it in a text box. Do I need to wrap it in something else to get it to read in the variable?
Thank you.
May be one of these
Sum({$<[CleanMonth]={'$(vNextSalesPeriod)'}, [ProdType]={'129'}>} Net_Revenue_Value)
Sum({$<[CleanMonth]={'$(=vNextSalesPeriod)'}, [ProdType]={'129'}>} Net_Revenue_Value)
Sum({$<[CleanMonth]={'$(=$(vNextSalesPeriod))'}, [ProdType]={'129'}>} Net_Revenue_Value)
May be one of these
Sum({$<[CleanMonth]={'$(vNextSalesPeriod)'}, [ProdType]={'129'}>} Net_Revenue_Value)
Sum({$<[CleanMonth]={'$(=vNextSalesPeriod)'}, [ProdType]={'129'}>} Net_Revenue_Value)
Sum({$<[CleanMonth]={'$(=$(vNextSalesPeriod))'}, [ProdType]={'129'}>} Net_Revenue_Value)
Agreed with Sunny; add single quotes around dollar-sign expansion for the month field