Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.