Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
I i've a chart wich display a year to date information, my problem is when i select several month's my Production costs information is incorrect but when i only choose one month it's correct, it seems to be doing some kind of average or something.
My expression: =sum({$ <Responsible = {"=RaiserPlantID=Responsible"}>} Auth*XRATE2USD)
When several Months are selected:
when only jan is selected:
as you can see the amounts are incorrect when several month are selected.
Try sum(if(RaiserPlantID=Responsible,Auth*XRATE2USD,0))
The problem is likely your set modifier Responsible = {"=RaiserPlantID=Responsible"}. The set is calculated for the entire chart, not a set per month. Perhaps you need to use an if statement instead. Perhaps this document helps understanding what's going on: set_analysis_intra-record.qvw
What you are saying it's the chart only set analyses once and i need it to do it per month, do you have suggestion how to accomplish with a if stat?
Try sum(if(RaiserPlantID=Responsible,Auth*XRATE2USD,0))
Thanks it worked, i had already tried something near your expression but the result was the same but at the time i couldn't understand the problem after your explanation the if statement makes sense. Thanks