Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II

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

0 Replies