I created a table whose columns where original “Text” but now converted to “Currency”.
However, when creating formulas, some of the columns that were originally Text are still considered Text so I need an extra verbose .ForEach(CurrentValue.ToNumber())
Why is this? Any way to correct the types so that I avoid the verbosity?
thisRow = [Hot Tub Cleaning],
[Selected Month Bookings].[Hot Tub Cleaning].ForEach(CurrentValue.ToNumber()).Sum(),
thisRow = Management,
[Selected Month Bookings].[Mgmt Fee].Sum(),