Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a following report in which I want to calculate sell through for a particular time period (say user selects date from 1st july 2018 till 30th july 2018 ) so corresponding sell through should be seen under the heading sell through EOSS till date
The expression for following above requirement is as follows:-
=num(
(sum( {< Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {">=$(From)<=$(To)"}, [Season Code] = {$(MasterCurrentSeason)} >} quantity_returns))
/
sum( {$<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received),'#,##0%')
and its working fine
But Now I want sell through before EOSS date and also want sell through after EOSS date. Please help
Hi,
Maybe like this
AFTER
=num(
(sum( {< Sold_Date = {">$(To)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {">$(To)"}, [Season Code] = {$(MasterCurrentSeason)} >} quantity_returns))
/
sum( {$<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received),'#,##0%')
BEFORE
=num(
(sum( {< Sold_Date = {"<$(From)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {< Sold_Date = {"<$(From)"}, [Season Code] = {$(MasterCurrentSeason)} >} quantity_returns))
/
sum( {$<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received),'#,##0%')
Regards
Hi
I want sell through till Eoss date. Following is the code for the same :-
=num(
(sum({$<Sold_Date = {">=$(From)<=$(To)"}>} quantity_sold) - sum({$<Sold_Date = {">=$(From)<=$(To)"}>} quantity_returns))
/
sum( {$<Received_Date = {"<=$(To)"}> } quantity_received)
,
'#,##0.0%')
and also want sell through Till date,so how to manage the same ??
Hi,
Maybe like this
sum( {$<Received_Date = {"<=$(To)"}>+<Received_Date = {">=$(From)"}> } quantity_received)
But here i have used the formula to calculate sell through
quantity sold - quantity return / quantity received. so now what should be the expression ?
ABOVE EXPRESSION IS GIViNG Me WRONG RESULT
May be this:
=Sum( {1<Received_Date = {"<=$(=Date(Today(), 'MM/DD/YYYY'))"}>} quantity_received)
The below expression is not giving correct result
=num(
(sum( {stateperA< Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {$(Master_PreviousSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(From)<=$(To)"}, [Season Code] = {$(Master_PreviousSeason)} >} quantity_returns))
/
sum( {$<[Season Code] = {$(Master_PreviousSeason)} >} quantity_received)
,
'#,##0%')
May be modify the above expression like this:
=num((sum({stateperA<Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {"=$(Master_PreviousSeason)"} >} quantity_sold)
- sum({stateperA<Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {"=$(Master_PreviousSeason)"} >} quantity_returns))
/
sum({$<[Season Code] = {"=$(Master_PreviousSeason)"} >} quantity_received),'#,##0%')
Try with this too:
=num((sum({stateperA<Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {'=$(Master_PreviousSeason)'} >} quantity_sold)
- sum({stateperA<Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {'=$(Master_PreviousSeason)'} >} quantity_returns))
/
sum({$<[Season Code] = {'=$(Master_PreviousSeason)'} >} quantity_received),'#,##0%')