Chart not calcluating correclty

[samuel_brierley]

I have a Chart that I have used many times and just change the dimensions but for some reason when I change the dimension to contract it gives in.

the chart should multiply the hours worked on a contract by the Rate.

I have previewed the data and I can clearly see for example a contract with hours booked to it and a rate assigned but the chart just wont do it.

The drop box link is a very small except of what Im doing and more importantly what isnt working.

Im only a desktop user so unfortunatly I am unable to open other qvw. thanks for the help

Dropbox - boo.qvw

[#2]

Hi Samuel,

Try this formula

=sum({$<Contract={"*"}>} [Total Hours] * Rate )

Hope it helps. Let me know if you have any questions

Thanks

AJ

[MayilVahanan]

HI

PFA

Hope it helps

Total hours: =sum({$<Contract={"*"}>} [Total Hours])

Rate : Sum(Rate)

Total Hours * Rate :  =sum({$<Contract={"*"}>} [Total Hours])* Sum(Rate)

[samuel_brierley]

thank you this is sorted, such a small buuger of an error