Cperez42985 Red Ribbon

Thank you Dominica, I did some testing on that formula yesterday and it looks like I still get the same amounts prediscount.

Below is a screenshot of one of the orders. However, we have some customers that get multiple discounts so some orders have discounts both at the header level and line level. I pasted a copy of both as well as my search results.

Trying to use the "Last quarter to date" and get this error message. I can't seem to figure it out. : Illegal argument: Type mismatch error: Cannot match types to expression MINUS(TO_CHAR({trandate#RAW}, 'Q'), 1) (Error on line 1 column 34.) I'm also trying to figure out how to do YoY by quarter. So this quarter to date…

Thanks Jack! I appreciate the feedback here.

Sorry, The custom field is on the customer form using the Hyperlink field type.

Thank you so much! That did it, the rate field you suggested and the formula field fixed the 2 major errors I was running into.

We're happy to hear this. Please, feel free to share your future experience with Workbooks and formulas. I'll be glad to help you and others in our quite new "Analytic" community here. So, a new struggle.. I took one of your classes a long time ago and you gave us a formula sheet. I'm struggling to convert it to the new…

Thank you so much!!! I was getting so frustrated with a case statement and decided to see if signing up for this community would help. I am NOT disappointed.