Hallo,
I have a query with 5 columns. 1 column is based on a formula that can hold 1 or 0.
Now I only want to show the data if 'this' column is 1. Does anyone know how to do that?
it's basically like putting a restriction on the column saying only take 1. But since it's a formula it doesn't work. Also tried adding a condition saying
'this column' == 1, but these returned nothing.
Hi,
you can change the formula can hold 1 not 0 - then you will get the desired report.
for key figures not possible to resctirct with the vlaues it is possible to restrict only char.
Thanks,
Phani.
Hi Bart,
Also you can put a condition with Greater than 0 and this should display 1.
rgds
SVU
Add a comment