What excel like functions can we use in formulae? Round? Roundup? Rounddown? Floor? Sumif? Concatenate?
Thank you for writing to us!
Please click on
Add calculated value button inside the Field List to see the pop-up window for adding the new value. Here you will see which operators can be used in the formula. Compose the formula by clicking on operators and dragging the existing values to the
Please inform me in case of further questions.
Yes, I am aware of the workings of the field list. Also looked over the API. It seems like the functions I am looking for are not available
Thank you for letting us know that you double-checked the calculated values functionality and API.
The pivot table does not provide the functions you were asking about.