I need some assistance with the following
I have an IIF condition and it is as follows
=round((Sum(Fields!VDuration.Value) + sum(iif(not(Fields!STypeName.Value = "SS") and not(Fields!STypeName.Value = "UA "), Fields!SDuration.Value,0)))/ 60,2)
I want to change the above to as
> If the Stypename.value<> "SS" and Stypename.value <> "UA", then Vduration should not be calculated and the Sduration needs to be half which means sum( Vduration = 0 and Sduration = Sduration/2) ELSE
Please note :- both the duration are in minutes, thats why the above script has ROUND condition.
Any help is highly appreciated.