functions

Answered

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

3 answers

Public
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.
Regards,
Tanya

Public
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
 

Public
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,
Iryna

Please login or Register to Submit Answer