sheldonperry
New Member
- Joined
- Oct 16, 2016
- Messages
- 1
Hi,
I am having trouble finding resources on how to use wildcards in Excel Cube formulas. I use rollup coding for my gl accounts to create my financial statements. So I attach a code to my wage accounts like "WAGES-OPERATING" for my operating fund; and "WAGES-CAPITAL" for wages in my capital fund. So to add wages across both funds I was hoping there were wildcards (like "Wages% or Wages*") or other syntax that could accomplish this in a cube formula.
Thanks
Sheldon
I am having trouble finding resources on how to use wildcards in Excel Cube formulas. I use rollup coding for my gl accounts to create my financial statements. So I attach a code to my wage accounts like "WAGES-OPERATING" for my operating fund; and "WAGES-CAPITAL" for wages in my capital fund. So to add wages across both funds I was hoping there were wildcards (like "Wages% or Wages*") or other syntax that could accomplish this in a cube formula.
Thanks
Sheldon