Hello, I have measured 2 fields I want to subtract in a new calculated field. First field is a calculated field : min(Amount, [OperatingType, SessionId, Date]) The second field is just a number: Plantscount How can I do it? Thanks, Mia

Is it working now? With min(Plants count)-sum(min(Amount, [OperatingType, SessionId,Date])? Or still Mismatched aggregation?

Hi @Sanjeeb2022 , Thank u for the response, I can’t convert this - min(Amount, [OperatingType, SessionId, Date]) into a new calculation that uses the ‘over’ function. Do u have any suggestions? Thanks

Hi @miap can try Field1: minOver(sum(Amount), [OperatingType, SessionId, Date]) BR

Hi @ErikG , I receive an error when trying the subtract- plantsCount - minover(sum(Amount), [OperatingType, SessionId, Date]) I want to create this calculation- Plantscount - min(Amount, [OperatingType, SessionId, Date])

Is plantsCount already a calculated field? Maybe you can try sum(plantsCount) or avg(plantsCount)

Hi @miap - Please share the sample input data and expected output. Regards - Sanjeeb

Sample input: [image] The expected output is a calculation by farm: min(Plants count)-sum(min(Amount, [OperatingType, SessionId,Date]) For example- Dim: Farm ‘031-MVP’ Measure: 15840- (3230+3480) = 9130

Subtracting between 2 field

Q&A

Sanjeeb2022 December 17, 2023, 3:51pm 2

Hi @miap - Can you explore minOver on the calculated field and then try to do a subtract from the first field, use pre_agg also. Please see the same kin of question from the below link -

Regards - Sanjeeb

Topic		Replies	Views
Calculated fiel Q&A formatting , quick-sight , calculations	5	446	April 10, 2023
I would like to subtract one calculated field from another Q&A analysis , error , quick-sight , calculations , Business-Intelligence-Engineer	8	481	February 1, 2024
I want to subtract two aggregate value fields in quicksight using calculated field Q&A analysis , quick-sight , calculations	2	1791	July 12, 2023
Add calculated field Q&A quick-sight , calculations	3	531	March 7, 2022
Why I cannot use new Calculated field with "SumOver"/"Sum" function in other calculation? Q&A developer , error , quick-sight	5	146	September 23, 2024

Subtracting between 2 field

Related topics