

Creator II
2019-04-25
10:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to write a nested if condition
Hi,
I have to write a if condition expression in front end.
Currently my expression for 'Contract' dimension is :-
if([End date] > '$(vDynamicenddate)' or isnull(End date),'Contract','out of scope')
I have to add another condition in this same expression where
Contract end date < '$(vDynamicenddate)','Contract','out of scope')
so both condition should fill for this 'Contract' dimension:-
if [End date] > [Period end date] and Contract end date < [Period end date] here vDynamicenddate='Period end date'
I tried to write the expression but it's not working as expected, please help
291 Views
0 Replies
