Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Data value changes when published

Hi,   This has never happened before with me, not sure what may be causing this.  For some reason when I publish this report the data for 2022 is just completely changing the value.  This is happen...
Need Help
  • sraj's avatar
    sraj
    4 years ago

    Finally this is what helped

     

    = [dtd] => RangeStart and [dtd] < RangeEnd

     

    Before I was doing the =>RangeStart and [dtd] <= RangeEnd which was causing the duplication I guess.  Found an article that helped me fix this.  

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
4 years ago

I checked all the above suggestions and it is still the same.  To be specific the publised data looks like the desktop but when it is refreshed on the web the value changes.

 

Is there any other way for me to present this sum?

I need to show the total of two columns for that day that year ( would be any year selection) .

 

126235 (o_prot_count) + 367493 (a_prot_count) = 493728