Set analysis for if condition

[deep2021]

Hello Experts,

Can you please suggest how to write the set analysis for below condition in calculated dimension.

=if(BUDGET_ACTUAL='A',NET_RENTABLE_AREA) - if([VOYAGER_OCCUPANCY.BUDGET_ACTUAL]='A',[VOYAGER_OCCUPANCY.NET_RENTABLE_AREA_VYGR])

Thanks

[Nicole-Smith]

Set analysis is only for measures/aggregations. You'll need to use the if statement for a dimension (or do the calculation in the script).

[deep2021]

can you please suggest how to calculate the above logic in measures using set analysis.

[Durgadevi05]

best exeprience