hi,
I am using a invoice detail table to find the difference between Nov 1-30, 2014 and Nov 1-30, 2013., so i create a few group formulas, depending on which range, first one curmonth, second PriorMonth, and then i created another formula to add the qty to CurMoQty if CurMO, and likewise for priorMonth, then i created a running total field to sum CurMoQty, and reset on item, as it is grouped by item. and have the running total fields in the group footer.
is there a way to subtract the two running total fields, CurMoQty - PriorMoQty ??

DB,

I created a formula field called PlusMinus, and i added the expression as.

#CurrentTotalMON - #PriorTotalMON

which are the actual RTfields that were created to summarize the qtys.
i get a warning that states: This date time literal was not understood.

do i have the wrong syntax? i am sorry, very new to CRXI so big learning curve for me.

appreciate your responses!

DB,
that worked perfectly! I'm making it rain for you! :)