Wednesday, April 3, 2019

Item Saved Search to Show Quantity Sold per Month in Columns

Watch this video to learn how to create a search that shows Quantity Sold per month in columns.

Note: Below are the sample formulas shown in this video:

Formula (Numeric)= DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),0,{quantity})

Formula (Numeric)= DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),1,{quantity})

Formula (Numeric)= DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),2,{quantity})

Image

No comments:

Post a Comment