Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Scenario:
Total ITDSales =
if( Sum([Discount])>=1000,
num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales]) + sum([YTDSales]),'#,##0')
)
Total Customer Count
Count({<[Customer] ={"=Sum([Discount])>=1000"} >} distinct Customer)
Could you please help on same
Count({<[Discount]={'>=1000'} >} distinct Customer)
The above expression is working for me, can you give it a go?
Hi,
My expression need to be like this only because i do have customer having multiple discount amount and hence inner expression need to be like this
Count({<[Customer] ={"=Sum([Discount])>=1000"} >} distinct Customer)
What are you getting and what do you expect to get? Expression's syntax looks right, but difficult to say what might be wrong without having more details
Total ITDSales = if( Sum([Discount])>=1000,
num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales]) + sum([YTDSales]),'#,##0')
)
Total Customer Count
Count({<[Customer] ={"=Sum([Discount])>=1000"} >} distinct Customer)
I
May be try this
Count(Aggr(If(Sum([Discount]) >= 1000, Sum({$<BusinessDate = {'$(=Date(YearEnd([BusinessDate],-1), 'MM/DD/YYYY'))'}>} [ITDSales]) + Sum([YTDSales])), Customer))
may be try
Count({<[Customer] ={"=Aggr(Sum([Discount]),[Customer])>=1000"} >} distinct Customer)