Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to get the value that is equal to the initial date minus the end date. How can you use subtraction within your set analysis?
Sum({<[VitalSignset.Observation Unit Code]={'WE'}>}{1<[VitalSignset.Observation Value]=([VitalSignset.Create Date]-[VitalSignset.Observed Date]))
If you want to subract 1 measure from another, Use: Measure_1 - Measure_2.
If you want to remove second set expression data from first and then use in measure
then try
only({<1st_set_expression,Field_name_2=e({<Second Set expression>})>}Field_name)
You can also use two dimension to calculae like
Only({<Set_expression>}Field_1 - Field_2)
If you want to subract 1 measure from another, Use: Measure_1 - Measure_2.
If you want to remove second set expression data from first and then use in measure
then try
only({<1st_set_expression,Field_name_2=e({<Second Set expression>})>}Field_name)
You can also use two dimension to calculae like
Only({<Set_expression>}Field_1 - Field_2)