In my log (OS X System Log) I collect as transactions the time machine backup data.
I need to summarize the amount of backup that in the log is either listed as KB, MB or GB.
I created three rex, that fill me three fields with the amount of KB, MB and KB.
Now, I try to calculate these three field into a summary fields with
eval TM_Amount_Summary=TM_Amount_K/1024+TM_Amount_M+TM_Amount_G*1024
This works, as long as all three fields contain a value. Though, if for instance TM_Amount_G was not found in a particular transaction, the resulting TM_Amount_Summary remains empty as well.
The eval should work if one or two of the three fields would be empty. How can this be solved?
... View more