Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please can someone help me with an expression.
Fields:
Material
New Product (either 1 or 0)
Sales Value
I want to create an expression to calculate the total value of a material where the New Product field contains 1.
I appreciate this is very easy but I'm a complete newbie
Thank you!
Sum({<[New Product]={1}>} [Sales Value])
Sum({<[New Product]={1}>} [Sales Value])
Hi,
Try below
Dimension
Material
Expression:
Sum({<[New Product]={1}>}[Sales Value])
Regards
ASHFAQ
Sum({<[New Product]={'1'}>} [Sales Value])
or
sum(if(New Product]=1 ,[Sales Value]))
Try this:
=Sum({$<[New Product] = {1}>} Material)
Hope it helps!