Empower custom field to ignore empty
Posted: Thu Apr 14, 2016 7:24 am
I have made a simple Custom Field so the user can enter the %Moisture.
Another field which calculates the Dried Amount:
Dried amount = Amount/(100-%Moisture)*100
But not all of our samples are calculated on dried base. For those samples the %Moisture field has to kept blank.
In my report the ODB amount is reported even if the %Moisture field is kept blank. I guess Empower uses "0" for an empty field.
But if I leave the %Moisture field empty, I want Empower to give an empty output.
So if Moisture = " " then Dried amount = " "
And if Moisture = "0" then Dried amount = Amount
How can I make this work?
Another field which calculates the Dried Amount:
Dried amount = Amount/(100-%Moisture)*100
But not all of our samples are calculated on dried base. For those samples the %Moisture field has to kept blank.
In my report the ODB amount is reported even if the %Moisture field is kept blank. I guess Empower uses "0" for an empty field.
But if I leave the %Moisture field empty, I want Empower to give an empty output.
So if Moisture = " " then Dried amount = " "
And if Moisture = "0" then Dried amount = Amount
How can I make this work?