Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
='Total lbs Shipped: ' & num(if([Date Filter] = 'Both',
sum({<[Ship Date] = p(Date)> + <[Delivery Date] = p(Date)> + $<Carrier = {Boutin} >}lbs),
if([Date Filter] = 'Delivery',
sum({<[Delivery Date] = p(Date)> + $<Carrier = {Boutin} >}lbs),
sum({<[Ship Date] = p(Date)> + $<Carrier = {Boutin} >}lbs))),
'##,###.')& ' Lbs'
im working for a trucking company, this is my code above, im trying to find out the volume we carry with our carrier "Boutin", but the result turn out to be time frame insensitive, doesnt matter how i change the time frame, the result doesnt change at all.
please someone help me~~~
Do you have a sample file? With only the expression and no indication of your data model or the contents of your Date Filter and such, it isn't much to go on. I'm assuming you want it to filter based on date and it does not currently?
Do you have a sample file? With only the expression and no indication of your data model or the contents of your Date Filter and such, it isn't much to go on. I'm assuming you want it to filter based on date and it does not currently?
Hi Rebecca, i already fixed the problem, i forgot to use quote on my selection...