Edit Expression

[#1]

How can I add the Packed > 2017-06-12 00:00:00 to the logic below?

sum(If(Packed> '2017-06-12 00:00:00',Lables))

(Sum(if(Left(FormName,3)='Tab', Lables)))+(Sum(if(Left(FormName,3)='Cap', Lables)))-(sum(if(PartialTablet=-1, Lables)))

[sunny_talwar]

May be this?

Sum({<FormName = {'Tab*', 'Cap*'}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables) - Sum({<PartialTablet = {-1}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables)

[#3]

Shows blank

[sunny_talwar]

What is the format of the field Packed?

[#5]

2017-06-12 00:00:00

Datetime stamp

[sunny_talwar]

Can you try this

RangeSum(

Sum({<FormName = {'Tab*', 'Cap*'}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables),

-Sum({<PartialTablet = {-1}, Packed = {"=$(='>=' & Date(MakeDate(2017, 6, 12), 'YYYY-MM-DD hh:mm:ss'))"}>} Lables)

)

[#7]

Same thing blank

[sasiparupudi1]

May be try this

=sum({<FormName={'Tab*','Cap*'},Packed={'>2017-06-12 00:00:00'}>}Lables)-sum({<PartialTablet={'-1'},Packed={'>2017-06-11 00:00:00'}>}Lables)

[#9]

Well I get a zero now

[sunny_talwar]

Would you be able to share a sample?