ContributionsMost RecentMost LikesSolutionsXFgetcell pulls in future months as YTD negative How can I get xfgetcell formula to not pull in the next month as a negative? i am making a YTD file and currently have Jan and Feb number but march pulls in the YTD amount but negative and causes the...Quickview column formatting how can i get 2 columns on a quick view to be shown as %? Re: Quickview wildcard i am selecting a A# for a quickview. we have the first 3 numbers of the account designating it for warehouse, general, etc. is there not some wild card i could use and just type in A#5*4071 and it j...Quickview wildcard Is there something that can be used as a wildcard in OS? I have multiple accounts like 524000, 564000, 544000, etc. can I just plug something into the X for a wild card get all those accounts? "5X403...CubeView Comments can you have a comment field in a cube view wrap text? QuickView - MTD and YTD is it possible to get column E to show YTD values? if i change the view to YTD everything else changes to YTD. i tried using the getcelldata(#2022M1+2022M2 ......#2022M12) it works if i stop at #2022...Re: Quick views - blank row can you get to that screen form the excel add in? the only settings menu i can find is this Re: Quick views - blank row is there a way to include code to make "operating expense" bold by any change? A#None:Name("Operating Expense") Re: Quick views - blank row that works, thanks Quick views - blank row is it possible to add a blank row in the account field? i found that you can use A#None and it will make the numbers blank. is there something else you could use to make the numbers blank and ...Solved
