Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I was trying to get sales percentage against daily target but ended up getting the percentage against the total sales target
Eg: Daily target = 1500, Sales = 1000, Total daily target it 25000
Expected answer =66.67%
System answer = 4%
Can someone please suggest me how to restrict the denominator
Num(Count({$<
[SalesDate]={">=$(=Date(Today()-1)) "},
[Completed Within DL] ={"Y"} >} [Completed Within DL] ))
/Count([DailyTarget])
Thanks in advance
how is daily target associated to your sales dataset? can you post a snapshot of your data model