Get Free Trial


Paul Schlichter asked on July 31, 2018

What excel like functions can we use in formulae? Round? Roundup? Rounddown? Floor? Sumif? Concatenate?

3 answers

Tanya Gryshko Tanya Gryshko Flexmonster August 1, 2018

Hello, Paul,
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 formula box.
Please inform me in case of further questions.

Paul Schlichter August 1, 2018

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

Iryna Kulchytska Iryna Kulchytska Flexmonster August 2, 2018

Hi Paul,
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.
Kind regards,

Please login or Register to Submit Answer