I finally figured it out, the way to get it correct is to always have a range. So in my case entering just the one account the formula doesn't work but if I do a range even if the account is the same then the calculation comes out…"
Without the ability to see everything it's going to be difficult to assist any further.
I would edit the formula in the formula editor and check each component until you see it return a number. I believe there's…"
Yes I thought that could be the case or maybe because it ends with a 99, but the accounts are all the same for this row set.
Even worse now, if I do a range of accounts I get a figures but if I just have one account nothing is…"
The best I can do from here is suggest you compare the account(s) that do produce a value to the account that does not.
I think there is something different about the account the is not retrieved."
This is good. We have narrowed the source of the issue.
Is your formula retrieving the account balance or the period net change?
I am not clear on your meaning about actuals versus value for the period so the preceding is a best…"
Yes I did, it returns no data when I do so. I have also just tried on a blank worksheet and the result is the same. Weird though, Actuals for period 3 is showing -4132.46 but the value in that period is actually 13 678.56. When I drill down…"
One question for you: Did you try 18.104.22.168.99 on it's own to confirm the data comes through?
The formula looks good to me but I have found cases where there are really small things that are not readily visible that cause…"
Hi there,I'm creating a P&L using Report Designer and need to have it categorised as needed by my client.I'm noticing that some row sets are not pulling the data. For example I have added a row set "Insurance" with type "Account" and the rule is "22.214.171.124.1 to 126.96.36.199.4 + 188.8.131.52.99".On generating the report I see that account "184.108.40.206.99" is being omitted and I have checked to ensure that there is data for the specified period. I also have another one where the rule for Account is…See More
Good day, I picked interest on you after going through your short profile and demand it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on(firstname.lastname@example.org) for the full details.