Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an app which i need to create a calendar object where i am using auto generate based on date key feild;
it works fine and application relaods succesfully if the date key feild is not empty however my case is that sometimes this date key feild would be empty even though this feild is empty my application which is having auto generate based on this date key feild..
should not fail and dashboard should reload success.
Ideally i need to write lile - if datekey feild > 0 then autogenereate (days) or else autogenerate (0) which is proper number and makes dashboard successfi; reload
could some one help me out
there is no need for your calendar to be dependent on your fact dates.
Perhaps, keep the minimum date from your fact date field but maximum can be today or 1 year in future or whichever your use case may be
Hello,
Try this,
LET NumOfDays = Alt(End - Start + 1,0);
If you want to use "if" condition, you have to write like this.
LET NumOfDays = If(Not isnull(End - Start + 1), End - Start + 1, 0);