Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to build a set analysis expression which returns the result based on the date previous to the current selection.
My Date field is [Date] , formatted (18/07/2016) and my current expression is:
sum({<[Date]={'$(=Max([Date])-1))'},[Channel]={"Agg"},[Product]={"Motor"}>}[Quoted])
I'm guessing that not only is my syntax incorrect but also the result is a numeric value of the date which need formatting?
Any help would be greatly appreciated.
Many Thanks
Try this:
Sum({<[Date]={"$(=Date(Max([Date])-1, 'DD/MM/YYYY'))"}, [Channel]={"Agg"}, [Product]={"Motor"}>}[Quoted])
Update: Changes I have made are in red above
Try this:
Sum({<[Date]={"$(=Date(Max([Date])-1, 'DD/MM/YYYY'))"}, [Channel]={"Agg"}, [Product]={"Motor"}>}[Quoted])
Update: Changes I have made are in red above
in your expression one extra closing bracket is there i corrected it check this one
sum({<[Date]={"$(=Date( Max([Date])-1)"},[Channel]={"Agg"},[Product]={"Motor"}>}[Quoted])
Perfect.
Thank you.