Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

budget /revenue as the % for investment

hi folks,

i have data like this

idstart dateEnddateBudget
111/27/201111/16/20141000
211/27/201111/16/20142000
311/27/201111/16/20143000
411/27/201111/24/20134000

And i have revenue for one month

jan 2012 revenue =2000

% for investment=total budget/revenue (jan12)

how can i achieve % investment for jan 2012.

thanks in advance.

0 Replies