Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Percentage to Gross Sales

Hello all,

I have a small issue.  I need to display what percent my bottom line is to gross sales?  Any ideas?  The current percentages are based on this calculation.

IF(Dimensionality() = 1 and RowNo() <> 1,(sum({<MTDFlag = {1}>} [In company code currency_HSL] * -1 ) /
top(sum({<MTDFlag = {1}>} [In company code currency_HSL]
* -1 )))* -1) 

Thanks

0 Replies