If Formula with Roll Up Fields and Blank Values

App Development Data Builder
1

Hi, I’m trying to show a date in a table. It’s rolled up from a different table with a condition on a decision field. The condition would be met for two options in the decision field, but since I can only have “AND” conditions in roll ups I’ve set up two roll up-fields to get both field values. One of both will always be blank.
So what I want to do is use a equation to combine those two roll ups into one field.
I tried this:

if({Premiere + Load In/Out}="",{Premiere / ohne Load},{Premiere + Load In/Out})

but apparently my formula is invalid and I don’t see why.
What I want to achieve is the Formula field to show the datefield from the other table that is not blank.

2

Hi Andreas - this is just a guess. But I think your field names contain some restricted characters.

For example - I assume this is a field in your tadabase {Premiere + Load In/Out}
But that field name has characters that have mathematicial meaning like = + - / or *

If your field name was {Premiere and Load In_Out} it would probably be OK

3

renamed the fields and tried this:

if({Premiere  Load In_Out}="",{Premiere regular},{Premiere  Load In_Out})

stil invalid equation

4

Try this option:

IF(
{Premiere + Load In/Out} = ‘’ || {Premiere + Load In/Out} IS NULL,
{Premiere / ohne Load},
{Premiere + Load In/Out}
)

5 
if({Premiere Load In_Out}= " || {Premiere Load In_Out} IS NULL,{Premiere regular},{Premiere Load In_Out})

still invalid

6

alright I took a different approach, I assume the problem in the formula are the roll ups. So I’ve build an equation field in the child table:

if({Art} = "Premiere" || {Art} = "Premiere + Load In/Out",{Datum},"")

This field will be blank, when the type of day does not contain premiere. That way I just do a roll up on that equation field in the child table

1 Like
7

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.