Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_8
Contributor II
Contributor II

Percentage based on Daily targets

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 

 

Labels (5)
1 Reply
vinieme12
Champion III
Champion III

how is daily target associated to your sales dataset? can you post a snapshot of your data model

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.