Expression to calculate sales before given date and after date

[sakshikaul]

Hi

In the below chart I want to have sell through before date(start date as given in image) and sell through  (after end date )

Following expression i have used for Sell Through before (start date to end date )

=num(

(sum( {<  Sold_Date = {"<=$(Start Date)<=$(End Date)"},[Season Code] = {$(Master_CurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {">=$(Start Date)<=$(End Date)"}, [Season Code] = {$(Master_CurrentSeason)} >} quantity_returns))

/

sum( {$<[Season Code] = {$(Master_CurrentSeason)} >} quantity_received),'#,##0%')

Following expression i have used for Sell Through  till date (start date to end date )

=num(

(sum( {<  Sold_Date = {">=$(Start Date)<=$(End Date)"},[Season Code] = {$(Master_CurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {">=$(Start Date)<=$(End Date)"}, [Season Code] = {$(Master_CurrentSeason)} >} quantity_returns))

/

sum( {$<[Season Code] = {$(Master_CurrentSeason)} >} quantity_received)

,

'#,##0%')

Note here start and end date are present in inline table not a calender dates

Above expressions are giving incorrect results

Regards

Sakshi

[Anonymous]

Hi sakshi,

can you provide a sample app and expected out put?

Thanks

[Anonymous]

Hi Sakshi,

Can you share sample Application and expected results?

Best Regards,

Ashok