Expression Help

[#1]

Hi,

I doing what if analysis in straight table.

Need calculation for What - if Revenue = (What - if Price)*(What-if Sold).

For ref. please find the attached qvw.

Thanks in advance.

[giakoum]

What is the problem using =column(4)*column(5)?

[#3]

Hi,

If I multiply - Column (4)*Column(5) = Value is wrong.

for example =  205*39 = 7995, But in Straight Table it is 7893.

[giakoum]

yes because you are rounding up. If you change all number formats to fixed to with 2 decimals it will be exactly.

[#5]

It is not coming in my Straight Table, Can you please correct in QVW and revert to me.

Thanks

[giakoum]

Properties --> Number tab to set number format

[maxgro]

try this

(Sum(Seats) * (1+ $(vQty)/100)) * (([Booking Fees]) + $(vValue))