sum changes with time

[#1]

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.

[Gysbert_Wassenaar]

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

[#3]

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?

[Gysbert_Wassenaar · Accepted solution]

Try sum(if(RaiserPlantID=Responsible,Auth*XRATE2USD,0))

[#5]

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