Need help in expression

[saradhi_it]

I have requirement for a store-sales the product margin should be calculated based on the sales

example: 0-500     level1

        500-1000   level2

       1000-1500+  level3

i tried to use interval match but how can i calculate the sales based on the levels ,sample data was attached

[sujeetsingh]

I do not see any issue in this . Well please explain me the motive of date here?

You can create sum all sales having margin >0 and <=500 as level 1. Post a sample app and explain the functionality.

[saradhi_it]

where should i put in the expression for day1 sales 1000 and day2 sales 500

my doubt how can i create condition based on date and and the level buckets

[effinty2112]

Dear Pardha,

                         Maybe something along these lines:

Pick(RangeMin(3,Ceil(Sum(Sales)/500)),

-------------, //Level 1 calculation here

-------------, //Level 2 calculation here

-------------, //Level 3 calculation here

)

Cheers

Andrew