Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all I want to count the in between days of sales and credit with some filters
actual calculation works in a table, but need to work in text object
interval(SALES_Date - CREDIT_DATE,'d')
FILTERS
=({<Brand = {'Shoe'},Mode={'Direct'}>}
Please Suggest
If this filter reduces to a single possible value, you could use expression like:
=Only({<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))
For multiple possible values, you might want to use Sum() instead, like:
=Sum({<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))
Or, if you see the result is coming in multiples of expected value, you might just have to use DISTINCT, like:
=Sum(DISTINCT {<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))
If this filter reduces to a single possible value, you could use expression like:
=Only({<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))
For multiple possible values, you might want to use Sum() instead, like:
=Sum({<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))
Or, if you see the result is coming in multiples of expected value, you might just have to use DISTINCT, like:
=Sum(DISTINCT {<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))
May be this?
=Only({<Brand = {'Shoe'},Mode={'Direct'}>} interval(SALES_Date - CREDIT_DATE,'d'))