expression for calculating a sales on daily basis

[sakshikaul]

Hi

In the following image i want to write an expression for the following:-

1. I want the user to select date from calender for eg 1st june till 18th june 2018 and the sales should be displayed in the following chart .If suppose user selects start date as 14-6-2018 so sales for that period should be displayed individually like 14-6 2018 should have budget and sales under column MRP daily target and MRP daily achievements respectively

what all changes should be done in following expression ?

=num(sum({<BugetDate = {">=$(From)<=$(To)"} >} [inv value]/Sales_INR_Unit),'#,##0.0')

[sakshikaul]

anilbabu‌

[kakani87]

In the above expression shared by you considered the dates range Fromdate and Todate fields so if you remove the set expression as budget date = {<BugetDate = {">=$(From)<=$(To)"} >} from yours

Like this =num(sum( [inv value]/Sales_INR_Unit),'#,##0.0')

Try with out considering set expression

[balabhaskarqlik]

May be like this:

num(Sum(aggr(sum([inv value]),BugetDate,Sales_INR_Unit)),'#,##0.0')

num(Avg(aggr(sum([inv value]),BugetDate,Sales_INR_Unit)),'#,##0.0')

[sakshikaul]

Here I am getting same values for the date selected by user in the calendar (check values under heading MRP daily achievements )

[sakshikaul]

here i am getting value as 0

[sakshikaul]

HERE IS THE DATA MODEL

[sakshikaul]

Pease help

Re: Date range in set analysis

stalwar1