Forum Discussion

mavbaumer15's avatar
mavbaumer15
Frequent Visitor
5 years ago
Solved

Data Always Loading on Report as 0

Hi,    I have never seen antyhing like this before... I had created this report a long time ago and now all of sudden this week the amount column on the dataset will only show as 0.  If I got into ...
Need Help
Show and Tell
  • mavbaumer15's avatar
    mavbaumer15
    5 years ago

    I'm not seeing the same thing...so sorry about this.  I'm not sure what happened with our data but I think I have found the issue and am fixing it in the backend. Thanks for looking at this and sorry for wasting your time. 

jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

It seems like the total is summing to 0?  I exported to excel and the sum of the REPORTINGCURRENCYAMOUNT is 0

so I added a Sign column to your table to split it up to check.

 

Sign = 
SWITCH(
    TRUE(),
    VendorInvoiceTransactionsWithGLDetail[REPORTINGCURRENCYAMOUNT] < 0, "-",
    VendorInvoiceTransactionsWithGLDetail[REPORTINGCURRENCYAMOUNT] > 0, "+",
    "0"
)

 

 

This is the measure in the values

 

Measure = SUM(VendorInvoiceTransactionsWithGLDetail[REPORTINGCURRENCYAMOUNT])

 

with the sign column on the columns.

 

mavbaumer15's avatar
mavbaumer15
Frequent Visitor
5 years ago

I'm not seeing the same thing...so sorry about this.  I'm not sure what happened with our data but I think I have found the issue and am fixing it in the backend. Thanks for looking at this and sorry for wasting your time.