Comment on XDF Conversion

Frank_and_Beans · Post by **Frank_and_Beans** » Mon Sep 13, 2010 5:30 pm

I think it is really cool that you can now have a matrix of conversion formula for each table in your XDF.

The way it appears to work now, is that the cell conversion overrides all other conversions, the column conversion overrides the general, etc.

I think it would be cool if all the conversions were cumulative. In other words, you could have individual cell conversions, but still apply the column conversion on on top of the cell conversion, and then the global conversion on top of everything.

I realize that this doesn't really add any functionality (as you would achieve the same output by just changing all the individual cell conversions), but would result in less typing when you need different cell conversions, and make conversions easier to change in general. The way it is setup right now is a little confusing, because when you apply a cell conversion, the global conversion is still showing, but no longer applies.

Just a thought. Not sure if it's worth working on or not.

Post by **Mangus** » Tue Sep 14, 2010 12:39 pm

Thanks for the suggestion!

Frank_and_Beans · Post by **Frank_and_Beans** » Sat Sep 18, 2010 3:04 am

Another feature that I would like to see pertains to emulating integer math a little better in the conversion.

It would be great if you implemented both ROUND and FLOOR functions. Usage would be similar to the excel version of these functions - ROUND rounds the number to a specified decimal, and FLOOR truncates a number to a specified decimal.

Also, as mentioned in another thread, there appears to be a problem with the IF function in conversions. I can't seem to get it to work using the operator as a output of the function. IF(X<20;X:X*2) doesn't work.

Thanks for listening to ramblings.

Post by **Mangus** » Sat Sep 18, 2010 7:09 am

In the IF function usage, what is X? The native value of the item?

Frank_and_Beans · Post by **Frank_and_Beans** » Sun Sep 19, 2010 2:35 am

Yeah, X would be the table value.

Frank_and_Beans · Post by **Frank_and_Beans** » Thu Oct 14, 2010 1:54 am

Looks like the IF function is now fixed in the latest release - SWEET!

I have another request relating to the IF Function now - Nested IF.

For instance

IF(X<20;X;IF(X<40;X*2;X*3)) Where X is the native value of the table. Doesn't seem to work properly now.

Post by **Mangus** » Mon Oct 18, 2010 12:47 pm

Investigating.