This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to follow your example for a similar objective. However, I want to round all of my values in each column to a whole number (i.e. with out any decimals). I have been doing this by using the Formula Tool and using the following formula for each column:
I would like to do this in a faster and much more efficient way as I now have over 100 columns and do not want to set up the Formula for each one of them.
Can I do this without having to type out the formula for each column using your example below?
Thank you so much! My team had a line of addresses and contact info pulling from PDFs but when a contact had more than one location they werent always submitting info for both - so we were able to sort by the contact and say if empty fill the one before it - complete list now! just used
IF ISNULL([ReportHeader]) THEN [Row-1:ReportHeader] ELSE [ReportHeader] ENDIF
Instead in the multi row. took us 2 days of failure before we found this--- again thank you!