10 posts in this topic
Hi Guys, I'm stuck to say I wonder if it has with brain power to do...
Table "Pencils" fields:
State Text | Has one of two values: "Activated" or "Deactivated"
Brand Text |Can be one out of many brands......
Pricetag Numerical |the price of each pencil
Sum_Pricetags_samebranded_and_activated pencils Calculation |?????
This is what I can't figure out for the last calculation field in the table "Pencils", How do I make a calculation out of the following:
In the calculation I want the Pencils from the same brand and with the same state "Activated" have their pricetags summed up and only if the two conditions are met.
2 pencils are of same brand and they are both in the state "Activated". The one pencil have a pricetag of 18£ and the second one have a pricetag of 10£
Because they are of same brand and both have the same state, I want their price to sum up, 18+10=28£
It does not matter what the field say if the conditions are not met for other records, the field then can stay blank.
IF Script skipping steps
I'm struggling with a script and count see what I'm doing wrong.
The frustration is its a simple script. For some reason the script will not action the second option. If red it will run red script if blue it will run blue script, but if green it moves down to the blue if and runs the blue script. I'm so confused. The script is just a trigger to run another script all three of which are the same just with different layouts. Any advice appreciated.
Multiple IF Tests
im trying to get my solution to generate pricing off of three separate fields and I'm stuck.
ex. If ( Package = "top 120" and Number of TVs = "1" and DVR = "no" ; "30" ; "" , If ( Package = "top 120" and Number of TVs = "2" and DVR = "no" ; "37" ; "" ))
that returns "too many parameters"
ex. If ( Package = "top 120" and Number of TVs = "1" and DVR = "no" ; "30" ; "") , If ( Package = "top 120" and Number of TVs = "2" and DVR = "no" ; "37" ; "" )
that returns "an operator is expected"
if done properly there would be 24 different "prices" generated from the combination of three fields. 3 different packages, # or tv's 1-4 and with or without a DVR. i know im close but cant seem to make it work, any help would be great
Lookup or if help to populate list
Hi there, I appreciate any help, I have two tables and I need one of them filled with the info from the other one
ID Name Subject 1 Subject 2 Subject 3 23 John 34 Tom
Id Name Subject Order Subject 23 John 3 Math 23 John 1 Bio 23 John Geo 23 John 2 Reading 34 Tom 2 Math 34 Tom 1 Geo And I want to populate the first table as this:
ID Name Subject 1 Subject 2 Subject 3 23 John Bio Reading Math 34 Tom Geo Math
Is it possible with any kind of lookup or if function?
IF Calculation Help.
I have a field named "time_status" and want this to change what it displays based on another field "status".
I want "time_status" to equal 'delayed' if "status" equals delayed.
I want "time_status" to equal 'departed' if "status" equals departed.
The last IF would be if "status" is empty I want "time_status" to equal another field named "time".
This is my first IF calculation and have read some online examples but they don't seem to be working.
Could someone guide me through this?