Hi, I am hoping you can help me resolve an issue I have noticed today. I am using a guage which measures volume until yesterday Vs an expected forecast until yesterday (Target = CALCULATE(sum(Forec...
Thanks Dkay84. Thats precisely the issue is. Is GMT vs local time. When I publish the report, it is calculating based on GMT instead of Sydney time. hence the difference between Desktop and published report. Any formulae that I can use to fix it so both Desktop and server agree?