H
Henrik Hansen
We need a math function like the calculate function available here: https://info.documotor.com/?page_id=282
Specific example, this returns the value of Acronis storage in bytes and I would like to be able to change that value to GB or TB for a report
sum(Usages[].usages[?name ==
local_storage
].value[]) 
like below for GB:
sum(Usages[].usages[?name == 
local_storage
].value[]) / 
1073741824
or if your JMESPath implementation doesn't support large numbers like this, you can achieve the same result by:
sum(Usages[].usages[?name ==
local_storage
].value[]) /
1024
/
1024
/
1024
or
sum(Usages[].usages[?name ==
local_storage
].value[]) *
0.00000000093132
I see in the documentation that there are subtract, divide and multiply functions like
sysinfo[0].subtract(totalUsers, mfaComplete)
sysinfo[0].divide(totalUsers, mfaComplete)
sysinfo[0].multiply(totalUsers, mfaComplete)
but they can not be used as they do not take for instance the result from the sum function or a pipe result as input like
sysinfo[0].multiply(sum(Usages[].usages[?name ==
local_storage
].value[]) , price_per_byte)
or
sum(Usages[].usages[?name ==
local_storage
].value[] | sysinfo[0].multiply(@ , price_per_byte)