Im looking for a formula when the Column Facturatie compleet says Nee. it will make the cell blank in column afwijking t.ov. raming(%).
Go to Solution.
I assume you've got a measure that's working out the current output where it's not Nee right now, so you want something like:
newmeasure = if([facturatiecolumn]="Nee",blank(),[existingmeasure])
View solution in original post
sorry for not being precise.
the output should be if Ja then do nothing. (show the value in afwijking...)
thx for your reply by the way
You should create new measure (or new calculated column) with condition, like above ( @jthomson).
Afwijking t.o.v. raming = if([Facturatie compleet]="Nee";blank();[Afwijking t.o.v. raming (%)])
Thank you all.
Greetings from the Netherlands,
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!