Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hope this is simple.
I need to have an expression that disregards all selections EXCEPT for the following
(1) Product = 'Books'
(2) Year Month of Sale = respect the selection(s) that is made
Confused on how I say disregard everything except for #1 and #2
Something like:
Sum({1<Product ={"Books"},[Year Month]=p([Year Month])>}Amount)
Hii,
i think you want to ignore the selections. You can ignore the selections by using the following script.
if you want the sum of Amount and that too only for Product = 'Books' then here is the syntax.
Sum({<Product ={"Books"},Field1 =,Field2=>}Amount)
And also the selection made in the Field1 and Field2 are ignored.
-Nilesh
Something like:
Sum({1<Product ={"Books"},[Year Month]=p([Year Month])>}Amount)
Worked perfect - thanks.