Excel formulae don't work in PAX

Post Reply
hadimulam
Posts: 5
Joined: Mon Feb 11, 2019 8:39 pm
OLAP Product: TM1
Version: PAX37
Excel Version: 2016

Excel formulae don't work in PAX

Post by hadimulam » Tue Apr 30, 2019 2:50 am

Hi,
We are using PAX 37 and noticing the following issues with some data entry sheets that were built with a bunch of DBRW formulas

1) When a cell containing DBRW formula, it takes calculations that results whole number(ex. 100/2 ) and doesn't like calculations that results with decimals (ex. 101/2). Also, other calculations 100*2 is not supported
2) Copying and pasting multiple cells allows paste as values only and sometimes the values don't get pasted properly

Please suggest if you implemented any solutions for the above problems. We like the tool but these kind of small issues are causing us headaches.

hadimulam
Posts: 5
Joined: Mon Feb 11, 2019 8:39 pm
OLAP Product: TM1
Version: PAX37
Excel Version: 2016

Re: Excel formulae don't work in PAX

Post by hadimulam » Wed May 08, 2019 7:51 pm

Can experts provide any suggestions pls?

User avatar
Steve Rowe
Site Admin
Posts: 1906
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Excel formulae don't work in PAX

Post by Steve Rowe » Thu May 09, 2019 7:17 am

Hi,

I suggest you provide some more detail, perhaps show us the formula that are working and not working and the results that are displayed in the cells. Or perhaps the workbook itself. e.g. You say "doesn't like" but you need to state exactly what the issue is, if its just display are you sure it is not an issue with formatting?

It sounds very odd and if it was something obvious happening the issue would be well known so the more detail you can provide the more likely it is you will get some pointers.

Post Reply