If Statement Issue

[#1]

Hi All,

I am trying to implement a Conditional statement based on the following criteria..

I have a list box called Technology. Each technology can be either a Product_Type WRT or TTL. So depending on the technology selected it will be either WRT or TTL. I have some rows in a table that I want to appear depending on whether the technology is WRT or TTL.

I tried using =GetFieldSelections(Product_Type) = 'WRT'

as the conditional experssion  - however this does not work unless I display the Produt_Type list box and actively select 'WRT', which I don't want the user to have to do. How can I test which product type group a  technology is in to enable the condition?

Many Thanks

John

[Gysbert_Wassenaar]

Try: aggr(only({<Product_Type={'WRT'}>} Technology), Technology)

or: if(Product_Type='WRT',Technology)

[Anonymous · Accepted solution]

IF(ISNULL(Only(Product_Type)), condition1, condition2)

[#4]

  Hi Michael

I modified yoiur suggestion as follows and it works perfectly

Only (Product_Type)= 'IIC'

[#5]

Hi Gysbert,

Thanks for your suggestion, while I didn't use it in this instance, I did use it in a case where I wanted to show the list price in a table for the Current Forecast without requiring the user to select the Current Forecast..

aggr(only({<ForecastVersion={$(vCurrent_Forecast)}>} [List Price]), [List Price])

However, I don't fully understand how this works, and can't find a good explanation onlline.. Could I ask you to explain the Aggr(Only(... part of the expression please?

Thanks

john

[arjunkrishnan]

if(isnull(Only(Product_Type)), condition1, condition2)