Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Samuel,
Try this formula
=sum({$<Contract={"*"}>} [Total Hours] * Rate )
Hope it helps. Let me know if you have any questions
Thanks
AJ
HI
PFA
Hope it helps
Total hours: =sum({$<Contract={"*"}>} [Total Hours])
Rate : Sum(Rate)
Total Hours * Rate : =sum({$<Contract={"*"}>} [Total Hours])* Sum(Rate)
thank you this is sorted, such a small buuger of an error