Search found 2 matches

by reynoldscm
Mon Apr 15, 2013 11:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using "IF" function with DBR/S formula
Replies: 5
Views: 4081

Re: Using "IF" function with DBR/S formula

Alan...you got me thinking and I was able to do the IF() elsewhere on the sheet and just use the DBRW formula. Thanks for jogging my brain a bit.
by reynoldscm
Mon Apr 15, 2013 11:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using "IF" function with DBR/S formula
Replies: 5
Views: 4081

Using "IF" function with DBR/S formula

I have a spreadsheet where I want to check a text value for each column. If the value = "Actuals" then I want to read the value from a cube, if the value = "Forecast" then I want to type a value into the cell and send it to the cube. It appears that if I have a formula that begin...