Recent content by DoneganF

Thanks all - looks like I'll use the global search & replace each time I add to the sheet. I was hoping to enter a custom number (currency) format to display null values as $0.00, but can't seem to work that out.

Is there a way to return a value of $0 in a pivot table for fields that have no dollar value. I'm spending a lot of time filtering and adding $0 to null values.

Thanks so much - that did the trick!

In Excel I have 2 pivot tables & 2 charts. Each pivot & chart set is sourced from one of two different data sources (charges & payments). I've create two other tables which contain the unique data shared by both of these tables (enterprise & financial division). I created all the necessary...

Thanks DBGuy .... very helpful. I figured the code was parked in the wrong place. I appreciate your help - and patience!

Hello All, I have a field on a report which I only want to display if the value is greater than zero. I tried the following code and parked it in the Report OnOpen Event. The error this codes generates is; "You entered an expression that has no value" Here's the code ..... Private Sub...

When I run the base expression, without trying to trap errors, certain records (where Charges = 0) will return the following error; #Num! Here is the base expression [PAYMENTS]/([CHARGES]-[CONTRACTUALS]) What I want the error expression to do is replace the #Num! with a 0.

I was actually looking for some suggestions on how to resolve the expression. But thank you for the advice on tagging future posts - I will definitely utilize tags going forward. Again .... any help on resolving the expression is greatly appreciated!;)

Hello All - I have an expression in a query in which I need to layer in an "If Error" clause. I tried the following, but received the error message; "The expression you entered has a function containing the wrong number of arguments" Here's the expression I entered...

He did make it a trusted site - and all the other macros are working as expected.

I have a list box which contains division names. I have that list connected to 4 charts, so that when I select a specific division, all 4 charts display the data for that division. It works exactly as I expect it to. However, when I handed the file off to my boss (also using Excel 2016) when...

Thanks DBguy - exactly what I needed. Now that I see this expression I feel pretty dumb - I should have been able to work this one out. I guess I was just over-complicating things by thinking I need one DateAdd nessted into another DateAdd. Again - your assistance is so, so VALUABLE, and I...

I'm using the follow expression as a query criteria to return the current fiscal year (July-June) value in the following text format; "FY 2020"; "FY " & Format(DateAdd("m",6,[Enter Date]),"yyyy") I now need to return the value for the prior fiscal year. So I thought I could wrap the above...

Ok, so one more question. I now need to return the exact same value - but for the previous year?

Thank you, thank you, thank you! Worked like a charm!:)