Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi sakshi,
can you provide a sample app and expected out put?
Thanks
Hi Sakshi,
Can you share sample Application and expected results?
Best Regards,
Ashok