web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps PowerApps Summing on I...

Power Apps

Unanswered

PowerApps Summing on If Else Depending on a Choice Field

(0) Share

Report

Report

Posted on by cnr

144

Hi all,

I am currently trying to Sum transactions where they are positive on a Sell and Negative on a Buy.

My 'transaction type' choice field is a Buy/Sell choice.

My SD date projects out how many days away the transactions are.

For this first column in my Clearcollect I have tried using an IF statement depending on whether my transaction is a Buy/Sell.

If the transaction is a Sell I am trying to Sum that trade amount positively, if its a Buy I am trying to Sum that trade amount as a negative number in order to show the net difference, hence the Else is 'trade amount' * -1

Currently I have tried using below below for the condition of the If statement - but none work:

[@'transaction type'].Value = "Sell"

'transaction type'. Value = "Sell"

'transaction type'= "Sell"

'transaction type'= 'transaction type'. Sell

Below is the current state of my code and the output on my App

Many thanks,

Conor

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @cnr ,

You can try below code if it works ?

'transaction type'.Value = "Buy" or 'transaction type'.Value = "Sell"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation