Jump to content

Convert excel function to Spotfire function

Allyson Brockwell

Recommended Posts

I am trying to convert the following excel function into a spotfire function:

=IF(COUNTBLANK(INDIRECT("$D"&$K12):INDIRECT("$D"&$L12))=0,"All packages have weights","Missing some package weights")

Background on the function:

Every row has a column that shows which is the first row and last row to contain the same value in column A - these are columns K (first) and L (last) in the function

The function is suppose to look at all the rows that contain the same value in column A and check is there are any blanks within column B; if there are no blanks enter "All packages have weights" but if there are blanks enter "Missing some package weights" in a new column

Link to comment
Share on other sites

Do you need an actual data function written or can a calculated column work  Would it be possible for you to attach a spreadsheet of sample data so we can understand your situation a little bit better  I feel like we could help you create a calculated column but just need to see how you have your spreadsheet set up a little more clearly.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...