Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
i have filed dirctly coming from the datamodel
Outage Reference
In the front end
i am writing the expresion as
=num(Count(distinct if(isnull([Outage Reference]),incidentnum)),'#####,######') as Witht Outage
and one more expression as
=num(Count(distinct if(not isnull([Outage Reference]),incident_ref_num)),'#####,######') as WithOut Outage
I need to cretae a flag in the model as Withoutage as Yes and Without as NO so that i can remove the Graph and make it as filter
Outage
Yes NO
How can i do
in the model you Need to enhance the table
if(isnull([Outage Reference]),incidentnum)),'YES','NO') as With_Outage
if(not isnull([Outage Reference]),incident_ref_num)),'YES','NO'') as WithOut Outage
In the backend model
Ouatges
which shows as yes or no
Yes means with Outage
No means Without Outage
in the backend your outage reference shows two fields incidentnum and incident_ref_num
if they are identical you only need
if(isnull([Outage Reference]),incidentnum)),'YES','NO') as FlagOutage
In the backend you select yes or no. no checkboxes but a listbox
hi
i m getting this error
you Need to delete the right bracket (shown in red)
Also, it seems that you have two field definitions for With_Outage
Create a Field from back end like below
if(isnull([Outage Reference]),'Yes',
if(not isnull([Outage Reference]),'No')) as Flag,
I hope this will help you.
Regards
Ahmar