This content has been marked as final.
Show 2 replies

Re: mathematical calculation in Qlik script
Mohammed Mukram Ali Feb 18, 2018 2:59 AM (in response to virendra chawra)Hi,
if you want to Calcualte for each row % Revenue then you can use.
(([Booking Actual]/[Total Seats])([Budget Actual]/[Total budget rooms]))/[Budget Actual]/[Total budget rooms] as Revenue.
if you have multiple rows for same ID then you have to use group by function .
let me know if you need something more.

Re: mathematical calculation in Qlik script
Vikraant Pai Feb 19, 2018 12:38 AM (in response to virendra chawra)Hi Virendra,
You can use the formula you have mentioned , aggregating the values by ID.
Load
ID,
(sum(BookingActual)/sum(Total Seats)  sum(BudgetActual)/sum(Totalbudgetrooms)) / sum(BudgetActual)/sum(Totalbudgetrooms) as [%Revenue]
Group By ID ; ....
Check if this is possible in your data model.
Best Regards,
Vikraant