Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
the below one works
=Sum({
<[Customer Name] = {"=Sum(Sales) <= $(vSlidemax)"}>
}Sales)
in the hilighted string , i have to add this condition >=$(vSlidemin)
it means i need sum(sales) between $(vSlidemax) and $(vSlidemin)
thanks in advance
Try this:
=Sum({<[Customer Name] = {"=Sum(Sales) >= $(vSlidemin) and Sum(Sales) <= $(vSlidemax)"}>} Sales)
Try this:
=Sum({<[Customer Name] = {"=Sum(Sales) >= $(vSlidemin) and Sum(Sales) <= $(vSlidemax)"}>} Sales)
Perhaps This
=Sum({<[Customer Name] = {"'>=' & $(vSlidemin) '<' & $(vSlidemin)"}>} Sales)
OR
=Sum({<[Customer Name] = {"'>=' & '$(vSlidemin)' '<=' & '$(vSlidemin)'"}>} Sales)
it works. thank you
Anil you cannot compare Customer Name to a min and max date range my friend. This is not the right way to do it brother.
Ok Bro, Thanks for recommend me
sorry anil.
it is not working for me
No problem