User_7FQ8X Newbie

Hi, Here's the formula: CASE WHEN {subscriptionline.recurringamount} IS NULL THEN '' ELSE {subscriptionline.recurringamount} END My hope is to get the formula to only effect the data for that single data point. However, what happens is the entire line of results is blank for any transaction that did not get generated from…

Hi, Here's the total hits found for this month transactions search. Here's the total number of visible lines that show up in the excel export. when I have the formula in the results tab that says to display the subscription line details if it exists. Here's what the data looks like in the report before lines 11659: Here's…

Hi, Here's a screen shot of the criteria screen: Here's the Results fields with the formula: The formula functions in the sense that it does not cause an error. However, No data is displayed in the Formula column. Screenshot of blank formula column results: Plus, the report only shows transaction lines generated from…

Hi, Here is the screenshot of the criteria of the Transaction search: I get 14,021 transactions and the excel data export shows 14,021 lines. However, the problem is when I add this line to the Results tab. I still get the same 14,021 transactions. However, the exported excel data only shows the transactions generated from…

Hi, Here's a screenshot of the results I get because there are prorated items in the results. The first line is the normal product line with the default sales prices. The second line is actually a prorated line from a subscription quantity change during the month. The price is much lower than the default price because of…

Hi, Sorry to keep bugging you about this. The formula worked as far as functioning properly in NS. However, the results are the same as using the field to grab the data. Both methods eliminate the Non Subscription transactions from the results that are exported. Question: Any other ideas on how to tell the query to display…

Hi, Thanks for the idea. Sorry to be unwise in the ways of NS. I found the Field ID from using the formula widget. It is called {subscriptionline.recurringamount}. This is the formula line I added as a currency and tried as text too: CASE WHEN {subscriptionline.recurringamount} IS NULL THEN '' ELSE…