LinkedIn
Twitter
Hello,
I'm currently working in a project and I have 2 columns that display a decimal value by a given formula.
my formula is: (POWER((7000/[Film Stress]),9))*1000000 and the value it displays is a type decimal being this number: 193,804,516.4285058000.
I'd like for that value to be 1.93804516429e8
I have another decimal value in a different column formula is:
(POWER((1.0/(2.0*3.1415926*[1 / Pulse Width or Ringing Frequency])),2.0))/([Desired Capacitance in µF]/1000000)
that actually converts itself to scientific notation whenever I change it from decimal to text however this value has more decimals so I think appsheet automatically converts it if it has many more decimals.
I attached a picture to show you how it displays both values in the top and bottom.
