Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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